WHERE
The WHERE clause extracts only those records that meet some criterion.
Syntax
SELECT columnA [, columnB, ... ]
FROM tableX
WHERE columnY <expression>
Example
SELECT ProductID, ProductName, ProductDescription
FROM /shared/examples/ds_inventory/products Products
WHERE ReorderLevel > 5