The comparison operators allow you to formulate conditions in SQL.
The following table shows the comparison operators available in SQL.
|<=||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.