Question

SQL applies conditions on the groups through ________ clause after groups have been formed?

• A. where
• B. having
• C. new
• D. all

Answer 1

The Correct Option is B

To apply conditions to aggregated data in SQL, the HAVING clause is employed. This clause processes data subsequent to its aggregation by the GROUP BY clause, enabling the filtering of these aggregated sets based on specific criteria. Contrasting with the WHERE clause, which filters individual records prior to aggregation, the HAVING clause operates on the entire groups created by GROUP BY.

The appropriate SQL construct for this conditional application to groups is:

• HAVING