Count for each group and sub-group
Hi,
I am writing a query to display group count and another count for the second group , something like this,
select id, names, dept, loc, country, gender from details group by dept, loc and also display their counts(for dept and loc).....it seems iam forgetting my sql here.....any help.