Which Department has MOST NUMBER of employees?

Answer Posted / senthil

select column_name,count(*)from table_name group by
column_name having count(*)=(select max(count(*)) from
table_name group by column_name);

PLZ Contact Any Queries (raja.prem86@gmail.com)

Is This Answer Correct ?    20 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to filter out duplications in the returning rows using oracle?

626


How to do clean up if create database failed?

555


How to invoke the original export import utilities?

490


What is dual table oracle?

517


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1553






What is Redo Log Buffer in Oracle?

615


What is a schema in oracle?

529


How to install oracle database 10g xe?

552


Explain an index segment?

625


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1773


How to rollback the current transaction in oracle?

530


Explain the use of record length option in exp command.

542


What is an oracle database table?

579


How to use "out" parameter properly?

616


How to create a new table in your schema?

595