A. Acts like a WHERE clause but is used for columns rather than groups
B. Acts like a clause but is used for rows rather than columns
C. Acts EXACTLY like a WHERE clause
D. Acts like a WHERE clause but is used for groups rather than rows
Explanation
The HAVING clause is used in SQL to filter groups of rows based on a condition, similar to how the WHERE clause filters individual rows.
The HAVING clause is applied after the GROUP BY clause, which groups the rows into sets, whereas the WHERE clause is applied before the GROUP BY clause.