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 thus functions as a filter.
+
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.