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
10163 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 difference between explicit and implicit cursors in oracle?

1115

Can we update views in sql?

989

Can we enter data in a table in design view?

1013

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

What are the three forms of normalization?

1092

How do you copy a table in sql?

1111

What are pl/sql packages?

1160

What is sql and also describe types of sql statements?

1114

What is sql injection vulnerability?

1005

Can we delete column in sql?

1176

how to check server status with 'mysqladmin'? : Sql dba

1134

What are the different types of constraints?

1282

Is join and inner join the same?

1044

What are different types of functions in sql?

1055

What is sqlca in db2?

1037