Changes

293 bytes added ,  22:15, April 1, 2008
m
Line 1: Line 1: −
A '''where clause''' is used in [[Structured Query Language]] (SQL) to determine a subset records which should be returned from a larger whole.
+
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.
 +
 
 +
[[Category:Computer Science]]