WHERE — Operators in T-SQL

The WHERE clause is used to filter rows based on conditions. SQL Server provides several types of operators for building these conditions.