SQL Query and Summary

[Soniya]

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

 

[Harald Staff]

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