Using the HAVING clause
The HAVING clause is used to filter out the groups that do not satisfy a condition given by an expression.
The HAVING keyword should be followed by an expression that returns a
Boolean:
HAVING expression
It is similar to the WHERE clause, but the HAVING clause is used to filter groups instead of individual objects. It should be used after a GROUP BY or a GROUP AS clause.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!