Write SQL statement that retrieve the department_name that has the maximum number of employees: Select one:
Write SQL statement that retrieve the department_name that has the maximum number of employees:
select d_name
from depart
where depart_id=(
select depart_id
from emp
having count(*)=
(select max(count(*))
from emp
group by depart_id)
group by depart_id);
select depart_name
from depart
where depart_id=(
select depart_id
from emp
where count(*)=
(select max(count(*))
from emp
group by depart_id)
group by depart_id);
select depart_name
from depart
where depart_id=(
select depart_id
from emp
having count(*)=
(select max(count(*))
from empl
group by depart_id));
select depart_name
from depart
where depart_id=(
select depart_id
from emp
having count(*)=
(select max(count(*))
from emp
group by depart_id)
group by depart_id);
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
