Published Jun 4, 2021Updated Sep 3, 2021
Contribute to Docs

Filters records (rows) that match a certain condition.


WHERE is a clause that indicates you want to filter the result set to include only rows where the following condition is true.

SELECT column_name(s)
FROM table_name
WHERE condition;


The given query will select all records where the pub_year equals 2017.

SELECT title
FROM library
WHERE pub_year = 2017;

All contributors

Looking to contribute?

Learn SQL on Codecademy