> > >

LAMP MCQs

Check the structure of the following tables:

Employee
---------
Empno
Employeename
Salary
Deptno

Department
---------
Deptno
Departname

Mike wants to see the departments that have more than 100 employees. Which of the following queries returns the required result?

Select departname from department where deptno in (select deptnofrom 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 deptnofrom employee group by deptno having count(*) > 100);

Explanation:

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

LAMP Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it