select dept_id from emp group by dept_id having count(*)=(Select max(count(

Which Department has MOST NUMBER of employees?

Question Posted / aswini

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

Answer Posted / aswini

select dept_id from emp group by dept_id having count(*)=(Select max(count(*)) From Emp group by dept_id)

Is This Answer Correct ?

2 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain mutating triggers.

974

What is varray?

1036

How to define an anonymous block?

1075

What exactly do quotation marks around the table name do?

918

How to see free space of each tablespace?

969

How to add another datafile to a tablespace?

994

Explain a segment?

1020

What are the advantages of oracle?

963

How to assign a table row to a record variable?

969

How to name query output columns in oracle?

1133

what is reindexing?

1611

How to start a specific oracle instance?

991

How to estimate disk space needed for an export job?

992

What is the difference between post-database commit and post-form commit?

1108

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2262