# WHERE in T-SQL: an overview

A WHERE clause keeps only the rows that match a condition, such as the customers in one country.

![Cheat sheet: WHERE in T-SQL: an overview](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/664dbc7d505f47298ad99aedc41fda73.webp)

- Category: SQL
- Level: Novice
- Tags: Comparison Predicate, sql, t-sql, where
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/where-in-t-sql-an-overview-cheat-sheet