Question 7684 – UGC-NET DEC-2019 Part-2
November 27, 2023Question 15976 – STQC-NIELIT STA 2021
November 27, 2023Question 7687 – UGC-NET DEC-2019 Part-2
Given two tables EMPLOYEE (EID, ENAME, DEPTNO)
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
Correct Answer: B
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
Subscribe
Login
0 Comments