An SQL primer
So far we've performed operations that retrieve all rows from a table.
To retrieve only certain rows, use the WHERE clause:
- SELECT col_list FROM tablename WHERE predicate
predicate evaluates to a condition that causes only certain rows to be displayed.