Comparison Operators & Functions

This page contains the Comparison operators supported by e6data.

Operator	Description
<	less than
>	greater than
=	equals
<>	not equals
<=	less than equal to
>=	greater than equal to

IS NULL

Returns boolean when the value equates to null.

> select * from table where col1 IS NULL; -- true/false

IS NOT NULL

Returns boolean when the value does not equate to null.

> select * from table where col1 IS NOT NULL; -- true/false

IN( value1, value2, value3...)

WHERE element IN (expr1, expr2, expr3...)

Returns a boolean value true if the element value is present in the given set of expressions. Else false is returned.

> select colA from Table1 where colB in (val1, val2, val3);