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
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 a tablespace? : Sql dba
How does sql developer connect to oracle database?
What is recursive join in sql?
What is server name sql?
What are all different types of collation sensitivity?
How to add a column ‘salary’ to a table employee_details?
how to select first 5 records from a table? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Does sql profiler affect performance?
What is the difference between python and sql?
What does trigger mean in slang?
What is the difference between inner join and outer join?
Difference between global and parameter variables?
Explain correlated query work?
What is a table?