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


Please Help Members By Posting Answers For Below Questions

what are the features and advantages of object-oriented programming? : Sql dba

556


what is 'mysqladmin' in mysql? : Sql dba

542


What is bind reference and how can it be created?

588


What is the starting oracle error number? What is meant by forward declaration in functions?

551


Can we debug stored procedure?

533






Why is sql*loader direct path so fast?

607


What is the difference between a database and a relational database?

569


What is memory optimized?

568


How many disk partitions should I have?

560


Why is %isopen always false for an implicit cursor?

578


Is sql considered coding?

575


How to add, remove, modify users using sql?

576


How can we make an if statement within a select statement?

549


How can I get the number of records affected by a stored procedure?

586


How do I run pl sql in sql developer?

639