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 are the features and advantages of object-oriented programming? : Sql dba
what is 'mysqladmin' in mysql? : Sql dba
What is bind reference and how can it be created?
What is the starting oracle error number? What is meant by forward declaration in functions?
Can we debug stored procedure?
Why is sql*loader direct path so fast?
What is the difference between a database and a relational database?
What is memory optimized?
How many disk partitions should I have?
Why is %isopen always false for an implicit cursor?
Is sql considered coding?
How to add, remove, modify users using sql?
How can we make an if statement within a select statement?
How can I get the number of records affected by a stored procedure?
How do I run pl sql in sql developer?