Which Department has MOST NUMBER of employees?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
what are the advantages of running a database in archive log mode?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What do you know about normalization? Explain in detail?
What are the major difference between truncate and delete?
Explain what are the uses of rollback segment?
Difference between NO DATA FOUND and %NOTFOUND?
What is the recommended interval at which to run statspack snapshots, and why?
What is Reduced List of Values?
Whether any commands are used for months calculation? If so, what are they?
How do we get field details of a table?
How do you tell what your machine name is and what is its IP address?
Query to retrieve record for a many to many relationship ?