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 |
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
what is the syntax of UPDATE command?
State some uses of redo log files?
Can multiple columns be used in group by in oracle?
How many types of tables supported by oracle?
How can I create database in oracle?
How to change program global area (pga) in oracle?
How to specify default values in insert statement using oracle?
What is the difference between a hot backup and a cold backup in oracle?
How a database is related to tablespaces?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.