Filtering Aggregate Results

In SQL, the HAVING clause is used to filter aggregate results as the WHERE clause cannot be used with aggregate functions.

We will be using the classicmodels database, which you can download from mysqltutorial for this article.

The Products Table

The products table contains data about the products available. Below, you will find a subset of the columns and rows in the table.

The Having Clause

We want to find the product lines that have at least 15 items in the catalog. This can be accomplished using the aggregate function COUNT and the HAVING clause.

SELECT
   productLine,
   COUNT(productLine) 
FROM
   products 
GROUP BY
   productLine 
HAVING
   COUNT(productLine) > 15 
ORDER BY
   COUNT(productLine) ASC;