The comparison operators allow you to formulate conditions in SQL.
The following table shows the comparison operators available in SQL.
| Operator | Description |
|---|---|
| < | Less than |
| > | Greater than |
| = | Equal to |
| <= | Less than or equal to |
| >= | Greater than or equal to |
| <> or != | Not equal to |
Expressions with comparison operators are referred to as predicates or Boolean expressions.
These expressions evaluate to TRUE or FALSE.
The outcome is UNKNOWN if you have rows with missing information.