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 the difference between clustered and non-clustered indexes?
What is the difference between sql and mysql?
How do I partition in sql?
how to convert character strings to dates? : Sql dba
what is union, minus and interact commands? : Sql dba
What are the types pl/sql code blocks?
what is online transaction processing (oltp)? : Sql dba
What is sql trigger example?
Write a query to display the current date in sql?
tell me about various levels of constraint. : Sql dba
Can we connect to postgresql using sql developer?
Can you join a table to itself?
What are sql functions? Describe in brief different types of sql functions?
How do sql databases work?
Explain clause in sql?