What is the significance of the statement HAVING COUNT (emp_id)>2 in – McqOptions

MCQOPTIONS

1.	What is the significance of the statement HAVING COUNT (emp_id)>2 in the given query?
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

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
What is the significance of the statement GROUP BY d.name in the given query?SELECT p.name, COUNT (emp_id) Per_noFROM Person p INNER JOIN Employee emON p.per_id=em.emp_idGROUP BY p.name
Which of the following belongs to an aggregate function ?
What is the meaning of GROUP BY clause in Mysql?
What is the significance of the statement GROUP BY d.name in the given query?
What is the significance of the statement HAVING COUNT (emp_id)>2 in the given query?
Which clause is used with an aggregate functions ?