Comparison Operators
| Operator | Description | Example | Result |
|---|---|---|---|
= | a is equal to b | 2 = 2 | TRUE |
!= | a is not equal to b | 2 != 3 | TRUE |
<> | a is not equal to b | 2 <> 2 | FALSE |
> | a is greater than b | 2 > 3 | FALSE |
>= | a is greater than or equal to b | 4 >= NULL | NULL |
< | a is less than b | 2 < 3 | TRUE |
<= | a is less than or equal to b | 2 <= 3 | TRUE |
IS NULL | TRUE if expression is NULL, FALSE otherwise | (4 >= NULL) IS NULL | TRUE |
IS NOT NULL | FALSE if expression is NULL, TRUE otherwise | (4 >= NULL) IS NOT NULL | FALSE |