Which Department has MOST NUMBER of employees?
Answer Posted / sts
Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max (count(*)) FROM EMP GROUP BY DEPTNO);
Is This Answer Correct ? | 24 Yes | 13 No |
Post New Answer View All Answers
How to define an oracle sub procedure?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are set operators?
What are the components of logical database structure in oracle database?
How do I uninstall oracle 11g?
How to define a cusotmer as a supplier in ORACLE R12
What do you mean by cdb and pdb in oracle 12c?
Explain the use of indexes option in imp command.
How to connect to a local oracle 10g xe server?
What is SQL Tuning Advisor in Oracle?
How do you tell what your machine name is and what is its IP address?
How to increment dates by 1 in oracle?
How to convert a date to char in oracle? Give one example.
How to create a table interactively?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?