select Count(gender) from emp group by gender with rollup

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 / venkat

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

Answer Posted / venkat

select Count(gender) from emp group by gender with rollup

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the maximum number of rows in sql table?

1030

How to use boolean type in select statement?

1076

what is a join? : Sql dba

1036

What kind of join is join?

972

What is java sql drivermanager?

1099

What is the difference between cluster and non-cluster index?

1108

What is a variable in sql?

1002

Which operator is used in query for pattern matching?

1089

What is the difference between a database and a relational database?

1103

What is pl sql package?

1033

How do I find duplicates in a single column in sql?

1020

What is a function in oracle pl sql?

1039

What is a parameter query?

1084

Is it important to partition hard disk?

1024

Is pl sql still used?

977