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
- 10157 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 relationship? How many types of relationship are there?
How can I get the number of records affected by a stored procedure?
What does the sign mean in sql?
What is full join in sql?
What is compilation error in pl sql?
What mean sql?
What are the possible values that can be stored in a boolean data field?
what is a primary key? : Sql dba
Is natural join and inner join same?
how is exception handling handled in mysql? : Sql dba
What is parallel hint?
what is the difference between union and union all? : Sql dba
What is package in pl sql?
How can you select unique records from a table?
What do you mean by dbms? What are its different types?
