select gender,count(gender)as gender_count from emp group by gender;

how to achieve this problem?i am having table with two
colums like empno,gender.
in gender column, i am having records male,female like that
.my final output will be
male female
5 6

Question Posted / sudeep ranjan

4 Answers
10027 Views
Hexaware, I also Faced
E-Mail Answers

Answer Posted / sudeep ranjan

select gender,count(gender)as gender_count from emp group
by gender;

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of primary key?

1029

How many types of triggers exist in pl/sql?

1073

What is the difference between distinct and unique in sql?

950

What is a temporal table?

930

What is view explain with example?

931

Is drop table faster than truncate?

990

How can I see all tables in sql?

1077

What is a temp table?

1026

What is left inner join in sql?

1045

what is index? : Sql dba

1006

Can we use two order by clause in query?

967

Does sql support programming?

1074

What is a ddl command?

1088

What are operators available in sql?

1048

What are tuples in sql?

1136