MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
What is the significance of the statement HAVING COUNT (emp_id)>2 in the given query?SELECT dep.name, COUNT (emp_id) emp_noFROM department dep INNER JOIN Employee emON dep.dept_id=em.emp_idGROUP BY dep.nameHAVING 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 | |