Query syntax
HAVING clause
The HAVING
clause is optional and eliminates group rows that do not satisfy a given condition. HAVING
is similar to the WHERE
clause, but WHERE
occurs before the grouping, and HAVING
occurs after.
This means that the WHERE
clause places conditions on selected columns, whereas the HAVING
clause places conditions on groups created by the GROUP BY
clause.
Here’s an example showing the position of the HAVING
clause in a SELECT query:
Basic HAVING
clause example:
This query results in a table with columns for department, job title, and average salary. Each row represents the average salary for a unique combination of department and job title, and only those groups with an average salary of at least $50,000 are returned.
Was this page helpful?