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
- 10070 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 the difference between truncate and drop statements? : Sql dba
What is recursive stored procedure?
define join and explain different type of joins? : Sql dba
Can we use view in stored procedure?
Why use triggers in sql?
What is the basic structure of an sql?
Differentiate between % rowtype and type record.
What is the difference between count 1 and count (*) in a sql query?
Does group by remove duplicates?
What are all the different normalization?
Can function return multiple values in sql?
how mysql optimizes distinct? : Sql dba
What is nvl?
Who developed sql?
What is dcl in sql?
