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 many categories of data types in oracle?
How to view the data files in the current database?
What are the database administrators utilities available?
How to get a list of all user accounts in the database?
What is the difference between Delete, Truncate and Drop in Oracle?
How to connect to a local oracle 10g xe server?
How to convert a string to a date in oracle database?
What happens in oracle commit?
What are the original export and import utilities?
various types of hints and their usage
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the uses of Database Trigger ?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are internal user account in oracle?
Explain joins in oracle?