Oracle SQL - Introduction Comparison Operators


The comparison operators allow you to formulate conditions in SQL.

The following table shows the comparison operators available in SQL.

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