12-02-2012 12:12 AM
The following query will give counts of each country_cd.But how to get the total of all counts?
select count(*) from table a
group by country_cd;
if there are 10 country_cd we will get 10 counts for each country.But how to get grand total of all 10 counts?