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

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 do you understand by exception handling in pl/sql?

579


How do I save a sql query?

546


What is number function in sql?

527


How many triggers can be applied to a table?

600


what is subquery? : Sql dba

572






What are records give examples?

566


Is sql pronounced sequel or sql?

742


What is meant by temporal data?

546


What is the difference between sum and count in sql?

528


Is pl sql better than sql?

552


What is the usage of the distinct keyword?

690


what are ddl statements in mysql? : Sql dba

579


What is an index in sql with example?

519


How do I tune a sql query?

514


Can we create index on primary key?

524