SQL> Select Deptno,Count(*) from Emp Group By Deptno Having

Which Department has MOST NUMBER of employees?

Question Posted / nannesaheb

8 Answers
50752 Views
IBM, LeadSquared, Mastek, I also Faced
E-Mail Answers

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

Differentiate between translate and replace?

1040

How to sort the query output in oracle?

970

How to create a table index in oracle?

1086

What is a dynamic performance view in oracle?

949

How to check database size in Oracle?

1119

List out the components of logical database structure of oracle database.

986

Explain the types of exception?

1083

Explain joins in oracle?

985

How many file formats are supported to export data?

1139

What is proxy method?

931

Please explain drop constraint oracle?

1029

How to write date and time literals in oracle?

949

How does the on-delete-cascade statement work?

1061

How to define a cusotmer as a supplier in ORACLE R12

2170

How to rebuild an index in oracle?

976