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
- 9248 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / sudeep ranjan
select gender,count(gender)as gender_count from emp group
by gender;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is dialect in sql?
Is sql better than access?
Can we use join in subquery?
What is union and union all keyword in sql and what are their differences?
How delete all records from table in sql?
What are hotfixes and patches?
Can we rollback after truncate?
what are the different tables present in mysql? : Sql dba
What is trigger point?
How do you use a while loop in pl sql?
What is difference between sql and mysql?
what is a composite key ? : Sql dba
What is composite primary key in sql?
In a distributed database system, can we execute two queries simultaneously?
What is dense_rank?
