The WHERE Clause

The WHERE clause is used to extract only those records that fulfill a specified criterion.

SQL WHERE Syntax

“SELECT column_name(s)
FROM table_name
WHERE column_name operator value”