# HAVING

WHERE filters rows before they're grouped; HAVING filters the groups afterward, by their aggregates. Know which to use, and the order a query's clauses run in.

![Cheat sheet: HAVING](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/a2c02abe98d84e0396dd72e508577e3a.webp)

- Category: SQL
- Level: Journeyman
- Tags: having, Query Order of Execution, sql, t-sql, where
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/aggregate-functions-in-t-sql-having-cheat-sheet