Difference between revisions of "Where clause"
Jump to navigation
Jump to search
(for example, small cities, having population less than 1,000 people, will be selected) |
Aziraphale (talk | contribs) (categorize) |
||
| Line 6: | Line 6: | ||
Only small cities, having population less than 1,000 people, will be selected. | Only small cities, having population less than 1,000 people, will be selected. | ||
| + | |||
| + | [[category:computer science]] | ||
Revision as of 04:56, August 4, 2007
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.