Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10165 Views
- Hexaware, I also Faced
- E-Mail Answers
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
What does sign mean sql?
What is forward declaration in pl sql?
How do I view tables in sql developer?
Why coalesce is used in sql?
What is the difference between cross join and natural join?
What does pl sql stand for?
Is crud a cuss word?
What happens when a trigger is associated to a view?
What is data type in sql?
What is the usage of sql functions?
What is the use of count (*) in sql?
Can you load data into multiple tables at once? : aql loader
How do I create a sql script?
What is not null in sql?
Differentiate between % rowtype and type record.
