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.