UGC-NET DEC-2019 Part-2
November 27, 2023STQC-NIELIT STA 2021
November 27, 2023Database-Management-System
| Question 424 |
Given two tables EMPLOYEE (EID, ENAME, DEPTNO)
DEPARTMENT (DEPTNO. DEPTNAME)
DEPARTMENT (DEPTNO. DEPTNAME)
Find the most appropriate statement of the given query:
Select count (*) ‘total’
from EMPLOYEE
where DEPTNO IN (D1, D2)
group by DEPTNO
having count (*) > 5
| Total number of employees in each department D1 and D2 | |
| Total number of employees of department D1 and D2 if their total is >5 | |
| Display total number of employees in both departments D1 and D2 | |
| The output of the query must have atleast two rows |
Correct Answer: B