| 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]] |