WHERE

Transact-SQL Reference

Transact-SQL Reference

WHERE

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

DELETE

Predicate

Search Condition

SELECT

UPDATE