WHERE (T-SQL)

Specifies the condition for the rows returned by a query.

Syntax

WHERE <search_condition>

Arguments

<search_condition>

Defines the condition to be met for the rows to be returned. There is no limit to the number of predicates in <search_condition>.

See Also