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
How to filter out duplications in the returning rows using oracle?
How to do clean up if create database failed?
How to invoke the original export import utilities?
What is dual table oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is Redo Log Buffer in Oracle?
What is a schema in oracle?
How to install oracle database 10g xe?
Explain an index segment?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to rollback the current transaction in oracle?
Explain the use of record length option in exp command.
What is an oracle database table?
How to use "out" parameter properly?
How to create a new table in your schema?