5.5

Using the HAVING Clause

Filtering Aggregate Functions With The HAVING Clause

  • The HAVING CLAUSE allows you to use an aggregate function as a filter. This is not allowed in a WHERE clause.
  • Any columns or expressions you want to use in a HAVING clause, MUST BE DEFINED IN THE SELECT CLAUSE as well.

Code Sample:

USE bike;
SELECT category_id, AVG(list_price)
FROM product
GROUP BY category_id
HAVING AVG(list_price) > 1000

Output:

ag_04.png

We previously discussed the preceding lines of code for this query so we will focus solely on the HAVING clause.

HAVING AVG(list_price) > 1000

This content is provided to you freely by BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/using_the_having_cla.