Where « Select Query « SQL Server / T-SQL

1.Query a single row
2.Limiting the Search result using where clause
3.Use variable in where statement
4.Where value 'IS NULL'
5.Using defined variables in where clause
6.WHERE clause conditions can either be simple or contain multiple conditions
7.An expression can also be a part of the condition in the WHERE clause
8.Use of a comparison operator in the WHERE clause
9.Use query in where clause