The HAVING clause does which of the following?

Answer:

Option A. Acts like a WHERE clause but is used for groups rather than rows.

Solution:

The HAVING clause of SQL is used for aggregate functions. It acts like a WHERE clause but is used for groups rather than rows. The WHERE clause applies conditions on the columns whereas the HAVING clause applies a condition to the groups formed by the GROUP BY clause. We can thus clearly eliminate options B, C, and D.