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
What do you understand by exception handling in pl/sql?
How do I save a sql query?
What is number function in sql?
How many triggers can be applied to a table?
what is subquery? : Sql dba
What are records give examples?
Is sql pronounced sequel or sql?
What is meant by temporal data?
What is the difference between sum and count in sql?
Is pl sql better than sql?
What is the usage of the distinct keyword?
what are ddl statements in mysql? : Sql dba
What is an index in sql with example?
How do I tune a sql query?
Can we create index on primary key?