select d.deptname, count(*) as cnt from Employee e inner join Department

Which Department has MOST NUMBER of employees?

Question Posted / cvsrao

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

Answer Posted / cvsrao

select d.deptname, count(*) as cnt from Employee e inner join
Department d on e.DeptId=d.DeptID
group by DeptName
having count(*) in
(select count(*) from
(select DeptId, count(*) as cnt from Employee group by DeptId)as cnt)

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rowid and rownum in oracle?

995

What is a table index?

1073

Can you create a synonym without having a table?

1022

What happens to the current transaction if a ddl statement is executed?

993

candidate key is subset of super key but not vice-verse explain

2057

What is oracle rownum?

931

Does oracle database need java?

985

How to add a new column to an existing table in oracle?

1116

Describe an oracle table?

1030

How to use fetch statement in a loop?

1007

Explain the use of record option in exp command.

987

What is a nvl function?

998

How to write text literals in oracle?

1059

What is a system tablespace and when it is created?

957

Can a formula column referred to columns in higher group ?

2490