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) |