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
10055 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 makes a good primary key?

1051

How to avoid duplicate records in a query?

1013

what is dbms? : Sql dba

1002

How do you explain an index number?

1116

What do you understand by exception handling in pl/sql?

1040

What are triggers and its uses?

1057

What is a string data type in sql?

1049

What is data definition language?

1097

How to call shell script from pl sql procedure?

1290

What is rollback?

1119

How do I view a table in sql?

1013

Why do we use procedures?

964

What is input buffer in sql*plus?

1234

What are procedures used for?

993

what is user defined functions? : Sql dba

1039