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
- 9257 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 is a database? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
Do ddl statements need commit?
How many sql statements are used? Define them.
What is an example of translating a date into julian format?
What are the usages of sql?
Explain the working of foreign key?
explain advantages of myisam over innodb? : Sql dba
Explain the uses of a database trigger?
What is restrict in sql?
Which command is used to call a stored procedure?
How do I run pl sql in sql developer?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How many types of privileges are available in sql?
What is the purpose of primary key?
