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