Summing columns in query results

[mmiram]

Hi:

I have a query as follows:

Select name, sum(transcount) As TransCount
from sumtrans
group by name;


Here is my question. In the resultant dataset, is there any way, I can sum everything in the TransCount column without using Reports. I want the query itself to sum that resultant column and show a grand total at the bottom.

Thanks,
Ram.

 

[PHV]

Select name, sum(transcount) As TransCount
from sumtrans
group by name
UNION SELECT 'Grand Total', Sum(transcount) FROM sumtrans

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244