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
What is truncate oracle?
What are the differences between date and timestamp in oracle?
How to use in conditions in oracle?
Explain the use of full option in exp command.
Explain view?
What are the attributes of the cursor?
What are named parameters?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Where is the export dump file located?
How a tablespace is related to data files?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is a view and how is it different from a table?
What are the original export and import utilities?
What do you understand by database schema and what does it hold?
List the various oracle database objects?