Performs a filter operation on a
SELECT query, by examining the
results of aggregation functions rather than testing each individual table row. Therefore, it is
always used in conjunction with a function such as
MAX(), and typically with the
GROUP BY clause also.
The filter expression in the
HAVING clause cannot include a scalar subquery.