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
9849 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 are the advantages of indexing?

929

What are stuff and replace function?

1017

What is the difference between inner join and left join?

939

What pl/sql package consists of?

1033

What are the different ddl commands in sql?

1067

How can we avoid duplicating records in a query?

925

Why select is used in sql?

970

What is a trigger in sql?

1158

what are myisam tables? : Sql dba

956

what is data control language? : Sql dba

959

What is primary key and foreign key?

917

How many postgresql users are there, worldwide?

995

Does pdo prevent sql injection?

886

Which version of sql do I have?

1000

How delete all records from table in sql?

930