Difference between revisions of "Where clause"
(it can be used to join related tables) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| 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. The where clause can function as a filter, selecting records that fit certain criteria, or it can be used to join related tables. | 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]] | ||
Latest revision as of 22:15, April 1, 2008
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.