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 / jayakrishnan
select count(case gender when 'male' then 1 end) Male,
count(case gender when 'female' then 1 end) Female from emp1
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Why do we use %rowtype & %type in plsql?
what is an extent ? : Sql dba
What is nested table in pl sql?
Explian rowid, rownum? What are the psoducolumns we have?
In a distributed database system, can we execute two queries simultaneously?
Can we perform dml on view?
What does partition by mean in sql?
What is indexes?
Does sql*plus also have a pl/sql engine?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What are the operators used in select statements?
What is meant by temporal data?
How do I run a pl sql program?
What is partition by in sql?
How to raise user-defined exception with custom sqlerrm ?