Which Department has MOST NUMBER of employees?
Answer Posted / nannesaheb
SQL> Select Deptno,Count(*) from Emp
Group By Deptno
Having Count(*)=(Select Max(Count(*)) From Emp);
--If Any Queries Contact Me at nannesaheb.c@gmail.com
--Nannesaheb
Is This Answer Correct ? | 8 Yes | 26 No |
Post New Answer View All Answers
What is set operator oracle?
What do you mean by group by clause?
Explain what does a control file contain?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain mutating triggers.
What happens if you lost a data file?
What is meant by joins?
What happens to the indexes if a table is recovered?
How to delete a column in an existing table?
Difference between pre-select and pre-query
Difference between the “verify” and “feedback” command?
What are the various constraints used in oracle?
How to list all indexes in your schema?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?