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_nameWHERE condition;
The given query will select all records where the
SELECT titleFROM libraryWHERE pub_year = 2017;
- Anonymous contributors
Learn SQL on Codecademy
- Anonymous contributorsAnonymous contributors