The WHERE clause of a SELECT statement specifies a condition that restricts which rows are to be included in the result table. Only the rows for which the condition is true will be included in the result table.

The WHERE clause is optional. If it is not specified, all rows in each of the tables and views will be included in the result table.