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
When do you get a .pll extension in oracle?
How to create a table index?
What is the difference between pre-select and pre-query?
What is bulk load in oracle?
What are group functions in oracle?
What are the different types of failures that occur in Oracle database?
Explain the use of file option in exp command.
How to get execution statistics reports on query statements?
Oracle
Can we insert data in view oracle?
What is MTTR advisor in Oracle?
How to estimate disk space needed for an export job?
What is user managed backup in Oracle?
What suggestions do you have to reduce the network traffic?
What is the parameter mode that can be passed to a procedure?