Sandeep Sharma

• Oct 24th, 2006

 

1. Select Male,Female,Other,(Male+Female+Other) total from
2. ( select count(*) Male from voters where gender = 1 ) A,
3. ( select count(*) Female from voters where gender = 0 ) B,
4. ( select count(*) Other from voters where gender is null ) C ;

sanju699369

 Profile Answers by sanju699369 

• Oct 24th, 2006

 

Select Male,Female,Other,(Male+Female+Other) total from

( select count(*) Male from voters where gender = 1 ) A,

( select count(*) Female from voters where gender = 0 ) B,

( select count(*) Other from voters where gender is null ) C

ora.nachs

 Profile Answers by ora.nachs 

• Feb 7th, 2007

 

Hi ,you can go for this also.Select count(decode(gender,?M?,name,null)) MALE,count(decode(gender,?F?,name,null)) FEMALE,count(*) TOTAL from emp_table;

vkc_keerthi

 Profile Answers by vkc_keerthi 

• Apr 14th, 2010

 

select
count( case when gender='M' then 1 end) "Male_count" ,
count(case when gender='F' then 1 end) Female_count,
count(*) Total_count from
temp1

neelapu

 Profile Answers by neelapu 

• Apr 16th, 2010

 

SELECT COUNT(decode(gender,'M',1,0)) "count of male",

COUNT(decode(gender,'F',1,0)) "count of Female",

COUNT(*) "Total Count"

FROM <table name>

GROUP BY gender;

neelapu

 Profile Answers by neelapu 

• Apr 16th, 2010

 

SELECT COUNT(decode(sex1,'F',1)) "female count", 

COUNT(decode(sex1,'m',1)) "male count", 

COUNT(*) "total count"  

FROM <table_name>

PK

• Feb 29th, 2012

 

There is one Oracle function ROLLUP, the same can be used for required output

QUERY:
SELECT GENDER,COUNT(GENDER)
FROM TABLE_NAME GROUP BY ROLLUP(GENDER);