hi !
could someone plz help me on this one,its kinda urgent
i hav a result set which looks something like this
country_code sum(amount)
1 100
2 123
3 213
i hav already used 'group by' clause to get the sum of amounts for
each country code
now i need to find the total sum of sum(amount) in the same query.How
do i do it???
i hav tried using an alias for the aggregated column and then trying to
get the sum of that column
but it does not work
plz help me out
regards,
Sangram