Which Department has MOST NUMBER of employees?




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 ?    3 Yes 0 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 ?    23 Yes 24 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 ?    0 Yes 2 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 ?    38 Yes 41 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 4 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 24 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 9 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 24 No

Post New Answer



More Oracle General Interview Questions

What is a snapshot log?

0 Answers  


What different of iner joint & outer joint with example

4 Answers  


What is the usage of save points in oracle database?

0 Answers  


What are advantages of dateset in datastage?

0 Answers   iGate,


What is a subquery?

0 Answers  






Whats the benefit of dbms_stats over analyze?

0 Answers  


What is an Oracle index?

0 Answers  


How to drop a tablespace?

0 Answers  


How to convert raw data type into text in oracle? Explain

0 Answers  


what is the difference between restoring and recovering?

0 Answers   MCN Solutions,


after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  


How to assign a tablespace to a users in oracle?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)