1.

What is the significance of the statement HAVING COUNT (emp_id)>2 in the given query?
SELECT dep.name, COUNT (emp_id) emp_no
FROM department dep INNER JOIN Employee em
ON dep.dept_id=em.emp_id
GROUP BY dep.name
HAVING COUNT (emp_id) > 2
A. Selecting those rows whose total emp_id > 2
B. Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id > 2
C. Filter out all rows whose total emp_id below 2
D. All of above
E. None of these
Answer» C. Filter out all rows whose total emp_id below 2


Discussion

No Comment Found

Related MCQs