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 rownum and rowid?
What is the starting oracle error number? What is meant by forward declaration in functions?
How do you rank data in sql?
what is the difference between where clause and having clause? : Sql dba
What is an alias command?
What is on delete restrict?
Is sqlite good enough for production?
What is the difference between count 1 and count (*) in a sql query?
What does a pl/sql package consist of?
what are the nonstandard string types? : Sql dba
What is the sql case statement?
Is sqlite free?
Explain select statements in sql?
Is sql the best database?
What are the ways on commenting in a pl/sql code?