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


Please Help Members By Posting Answers For Below Questions

What is set operator oracle?

504


What do you mean by group by clause?

533


Explain what does a control file contain?

582


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.

1234


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1775






Explain mutating triggers.

551


What happens if you lost a data file?

551


What is meant by joins?

599


What happens to the indexes if a table is recovered?

559


How to delete a column in an existing table?

570


Difference between pre-select and pre-query

550


Difference between the “verify” and “feedback” command?

739


What are the various constraints used in oracle?

534


How to list all indexes in your schema?

556


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1444