SQL Query and Summary
Hi Soniya
Its done in SQL Like this:
SELECT PRODUCT, REGION, SUM(AMOUNT)
FROM SALES
GROUP BY PRODUCT, REGION
ORDER BY REGION
HTH. Best wishes Harald
"Soniya" skrev i melding
...
Hi All,
Is it possible to make a summary at the same time of an
SQL query?
For eg. if I have various branches Detailed data in a
Table, can I have a Query to get only the Total for each
column for each Branch?
I can be more specific incase this is possible
TIA
Soniya
|