Which of the following belongs to an aggregate function ? – McqOptions

MCQOPTIONS

1.	Which of the following belongs to an aggregate function ?
A.	MIN/MAX
B.	COUNT
C.	SUM/AVG
D.	All of above
E.	None of these
Answer» E. None of these

Discussion

No Comment Found

Related MCQs

What is the significance of the statement HAVING COUNT (emp_id)>2 in the given query?<br><pre class="prettyprint lang-c">SELECT dep.name, COUNT (emp_id) emp_no<br>FROM department dep INNER JOIN Employee em<br>ON dep.dept_id=em.emp_id<br>GROUP BY dep.name<br>HAVING COUNT (emp_id) > 2<br></pre>
What is the significance of the statement GROUP BY d.name in the given query?<br><pre class="prettyprint lang-c">SELECT p.name, COUNT (emp_id) Per_no<br>FROM Person p INNER JOIN Employee em<br>ON p.per_id=em.emp_id<br>GROUP BY p.name<br></pre>
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 ?