SQL · Reading data

where

Filters rows before grouping. It cannot reference aggregate results; use HAVING for that.

sqlRunnable example sql course

Syntax

where condition

Example

Open in the lab

WITH lessons(title, minutes) AS (VALUES ('HTML', 12), ('CSS', 18))
SELECT title FROM lessons WHERE minutes >= 15;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.