> > >

PostgreSQL MCQs

The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, which query should be used?
Employee
---------
Empno
Employeename
Salary
Deptno
Department
---------
Deptno
Departname

Select departname from department where deptno in (select deptno

from employee group by deptno having count(*) > 100);

Select departname from department where deptno in (select count(*)

from employee group by deptno where count(*) > 100);

Select departname from department where count(deptno) > 100;

Select departname from department where deptno in (select count(*)

from employee where count(*) > 100);

Answer

Correct Answer:

Select departname from department where deptno in (select deptno

from employee group by deptno having count(*) > 100);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it