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' ;