Specifies a search condition that applies conditions to restrict the number of rows in the result table. If the query expression does not specify a WHERE clause, the result table includes all the rows of the specified table reference in the FROM clause.
Syntax
WHERE search_condition
Parameter
search_condition
Applied to each row of the result table set of the FROM clause. Only rows that satisfy the conditions become part of the result table. If the result of the search_condition is NULL for a row, the row is not selected. Search conditions can specify different conditions for joining two or more tables.
Example
For customers with orders, retrieve their names and order info:
SELECT Name, City, State
FROM Customer
WHERE State = 'NM' ;
