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