Which clause is used to “filter out unwanted Groups”?
(a) HAVING
(b) FROM
(c) WHERE
(d) SELECT
I have been asked this question in an internship interview.
This is a very interesting question from Query Clauses topic in section Query Optimization of MySQL