Limiting the Rows That Are Selected

- Restrict the rows that are returned by using the WHERE clause

SELECT *|{DISTINCT} column|expression [alias],....} FROM table 

[WHERE condition(s)]

- The WHERE clause follows the FROM clause.

- The WHERE clause can compare values in columns,literal values, arithmatic expressions, or functions.