Search⌘ K
Home
Courses
Learn SQL

Only Keep Interesting Groups

Filter grouped results using HAVING.

We'll cover the following...

You’ve grouped your data—now filter those results using HAVING. It works like WHERE, but for groups.

Goal

You’ll aim to:

  • Use HAVING to filter grouped results.

  • Keep only the summaries you care about. ...