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
10160 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 server name sql?

1204

What are the different operators available in sql?

1058

What are sql objects?

1129

Is sql similar to python?

1042

How is indexing done in search engines?

1023

What jobs use sql?

1032

is mysql query is case sensitive? : Sql dba

1164

What is difference between cursor and trigger?

1129

Explain what is a column in a table?

1158

Is like operator in sql case sensitive?

1077

What is the difference between distinct and unique in sql?

993

Whis is not false in primary key?

1522

Is pl sql a scripting language?

1082

What are the properties of a transaction?

1185

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117