Hi,
I have a table called 'T1' in that i have column like 'Gender', in that column i have 'male' and 'female' values. How to retrieve count(male) and count(Female) from T1.
Printable View
Hi,
I have a table called 'T1' in that i have column like 'Gender', in that column i have 'male' and 'female' values. How to retrieve count(male) and count(Female) from T1.
Select sum (decode (sex,'male', 1,0)) MALE, sum (decode (sex,'female', 1,0)) FEMALE , count (decode (sex,'M', 1,'F', 1)) TOTAL from t1;
Try this one also
select gender,coun(*) from t1 group by gender;