Difference between revisions of "Where clause"
Jump to navigation
Jump to search
(The where clause thus functions as a filter.) |
(it can be used to join related tables) |
||
| 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 | + | 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. |
Revision as of 23:08, August 2, 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.