Comparison Operators

Comparison operators are binary operators that return a boolean result.

Syntax

 
    select * from ... 
    where expression1 operator expression2
     

The eXtremeSQL comparison operators are the following:

=	Equal to
<>	Not equal to
<	Less than
<=	Less than or equal
>	Greater than
>=	Greater than or equal

Examples

 
    select 17 / 5 + 3;
    #1
    ------------------------------------------------------------------------------
    6
 
    Selected records: 1
     
    create table t(i integer, d date);
    insert into t values([3,5],['2017-01-01','2017-02-01']);
     
    select * from t where d > '01/01/2017';
    i       d
    ------------------------------------------------------------------------------
    5       02/01/2017 00:00:00
 
    Selected records: 1
     
    select * from t where d < now;
    i       d
    ------------------------------------------------------------------------------
    3       01/01/2017 00:00:00
    5       02/01/2017 00:00:00
     
    Selected records: 2