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 is file based approach?
Explain the difference in execution of triggers and stored procedures?
Explain locks? : Transact sql
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What do you mean by stored procedures?
How do I run a pl sql program?
How do you use a while loop in pl sql?
What is data modelling in sql?
Which table is left in left join?
What is range partitioning?
what is innodb? : Sql dba
What does (+) mean in sql joins?
what are date and time functions in mysql? : Sql dba
Why sql query is slow?
Can one improve the performance of sql*loader? : aql loader