where « Query « SQL Server / T-SQL Tutorial

1.2.1.All the operators we can use with the WHERE clause:
1.2.2.Calculation in where clause
1.2.3.Where with subquery
1.2.4.A SELECT statement that uses a subquery in the WHERE clause: greater than average
1.2.5.where in a subquery
1.2.6.The syntax of a WHERE clause that uses an IN phrase with a subquery
1.2.7.The syntax of a WHERE clause that compares an expression with the value returned by a subquery
1.2.8.WHERE clause can contain other comparison operators, including the following:
1.2.9.An expression can also be a part of the condition in the WHERE clause

1.2.10.Deal with divided by 0