Comparison operators

 

SQL supports several comparison operators.


Comparison operator Description
<> or ¬= or != Not equal to
= Equal to
< Less than
> Greater than
<= or ¬> or !> Less than or equal to (or not greater than)
> = or ¬< or !< Greater than or equal to (or not less than)

 

Parent topic:

Specifying a search condition using the WHERE clause