The syntax of the WHERE clause with comparison operators : Comparison operators « Query « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Query
  3. Comparison operators
WHERE expression_1 operator expression_2

The comparison operators
=   Equal
>   Greater than
<   Less than
<=  Less than or equal to
>=  Greater than or equal to
<>  Not equal








1.27.Comparison operators
1.27.1.The syntax of the WHERE clause with comparison operators
1.27.2.A SELECT statement that retrieves rows with non-zero values
1.27.3.Bankers located in Iowa
1.27.4.use a comparison operator to compare any two expressions that result in like data types.
1.27.5.Bankers with names from A to L
1.27.6.Billings on or after a specified date
1.27.7.Use the operator <> (instead of !=) to remain consistent with the SQL standard.