Which Department has MOST NUMBER of employees?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / pandeti.mahesh

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

Answers were Sorted based on User's Feedback

Which Department has MOST NUMBER of employees?..

Answer / sts

Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max (count(*)) FROM EMP GROUP BY DEPTNO);

Is This Answer Correct ?

24 Yes

13 No

Which Department has MOST NUMBER of employees?..

Answer / mady

In SQL Server / MS Access:
==========================
select top 1 department_name
from EMPLOYEES
join DEPARTMENTS
on EMPLOYEES.department_id=DEPARTMENTS.department_id
group by department_name
order by count(*) desc;

In My SQL:
============
select department_name
from EMPLOYEES
join DEPARTMENTS
on EMPLOYEES.department_id=DEPARTMENTS.department_id
group by department_name
order by count(*) desc
limit 1;

Is This Answer Correct ?

24 Yes

29 No

Which Department has MOST NUMBER of employees?..

Answer / ns

SELECT count(*), department_id
FROM employees
GROUP BY department_id
HAVING count(*) =
(SELECT max(count(*))
FROM employees
GROUP BY department_id)

Is This Answer Correct ?

40 Yes

46 No

Which Department has MOST NUMBER of employees?..

Answer / shibashis

Select d.deptname,count(*) as cnt
from employee e inner join dept d
On e.deptid=d.deptid
group by d.deptname
having cnt in (
select max(cnt) from
(SELECT deptid ,count(*) as cnt FROM employee GROUP BY deptid )
)
order by d.deptname
;

Is This Answer Correct ?

1 Yes

7 No

Which Department has MOST NUMBER of employees?..

Answer / 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

Which Department has MOST NUMBER of employees?..

Answer / senthil

select column_name,count(*)from table_name group by
column_name having count(*)=(select max(count(*)) from
table_name group by column_name);

PLZ Contact Any Queries (raja.prem86@gmail.com)

Is This Answer Correct ?

20 Yes

27 No

Which Department has MOST NUMBER of employees?..

Answer / 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

Which Department has MOST NUMBER of employees?..

Answer / 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