Where clause
This is an old revision of this page, as edited by Ed Poor (talk | contribs) at 23:09, August 2, 2007. It may differ significantly from current revision.
A where clause is used in Structured Query Language (SQL) to determine a subset records which should be returned from a larger whole. The where clause can function as a filter, selecting records that fit certain criteria, or it can be used to join related tables.
Examples
SELECT city WHERE population < 1000
Only small cities, having population less than 1,000 people, will be selected.