please help for this requirement is join sum of subtotal.
I have a result table like this. Picture Table
CID | STORECODE | STORENAME | CONTRACTNO | SUBTOTAL
---------------------------------------------------------
222 | SCI-SCG5 | S2 | 111 | 657,534.20
221 | SCI-SCG5 | S2 | 110 | 700,000
how to get result like this:
CID | STORECODE | STORENAME | CONTRACTNO | SUBTOTAL
----------------------------------------------------------
222,221 | SCI-SCG5 | S2 | 111,110 | 1.357.534,20
OR
STORECODE | STORENAME | SUBTOTAL
--------------------------------
SCI-SCG5 | S2 | 1.357.534,20
A Guide To Lighting Both Inside and Outside the Home
Home Gas Line Installation: What To Expect From the Service
Signs Your Water Heater Needs Repair
CVD vs HPHT: The Differences in Diamond Manufacturing
Lab Overgrown Diamond Earrings A Ultramodern Choice for Timeless Elegance
Bespoke Engagement Rings in the UK Are Winning Hearts
Dr. Larry Davidson: Emotional Resilience and Rehabilitation: The Mental Strength Behind Physical Recovery
The Financial Backbone of Healthcare: Revolutionizing Revenue Cycle Management Through Global Partnerships
Why Professional Kitchen Plumbing Installation is Essential for Your Home’s Efficiency and Safety
Why Professional Tankless Water Heater Installation is a Game-Changer for Homeowners