Binary Operators

Binary operators are used in where clause predicates to perform the indicated operation on two operands. The result is boolean true or false.

Syntax

 
    select * from ... 
    where val1 operator val2
     

The eXtremeSQL binary operators are the following:

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

Examples

 
    create table t(i integer, d date);
    insert into t values([3,5],['2017-01-01','2017-02-01']);
 
    select * from t where i = 1 or i = 3;
    i       d
    ------------------------------------------------------------------------------
    3       01/01/2017 00:00:00
 
    Selected records: 1
     
    select * from t where d < '2017-01-30';
    i d
    ------------------------------------------------------------------------------
    3 01/01/2017 00:00:00
     
    select * from t2 where i <> 3;
    i       d
    ------------------------------------------------------------------------------
    5       02/01/2017 00:00:00
 
    Selected records: 1