Using the HAVING Clause

Just as a WHERE clause reduces the number of rows returned by a SELECT clause, the HAVING clause can be used to reduce the number of rows returned by a GROUP BY clause. Like the WHERE clause, a HAVING clause has a search condition. However, in a HAVING clause, the search condition typically corresponds to an aggregate function used in the SELECT clause.

Controlling your Query with GROUP BY and HAVING

Issue the following query to list the departments that have an average budget of over $60,000 and order the result set by department.

SELECT Department, AVG(budget) FROM department

GROUP BY Department

HAVING AVG(budget) >60000

ORDER BY Department

The result set should look like this:

Advance To:

Ordering by an Aggregate Column