WHERE
Filters records (rows) that match a certain condition.
Syntax
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_nameWHERE condition;
Example
The given query will select all records where the pub_year
equals 2017
.
SELECT titleFROM libraryWHERE pub_year = 2017;
Contributors
- Anonymous contributors