DB2 UDB for iSeries SQL: Comparison operators

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)

Parent topic:
Specifying a search condition using the WHERE clause

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)