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
where are cookies actually stored on the hard disk? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is mutating table error?
How can you load microsoft excel data into oracle? : aql loader
What is sharding in sql?
List the different type of joins?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the ways on commenting in a pl/sql code?
how to get a list of indexes of an existing table? : Sql dba
How to select unique records from a table?
what are all different types of collation sensitivity? : Sql dba
Which sql statement is used to return only different values?
explain the difference between delete , truncate and drop commands? : Sql dba
What do you understand by pl/sql packages?
what is a trigger in mysql? : Sql dba