Logical Operators

This page contains logical operators supported by e6data.

<expr1> AND <expr2>

Returns true if both the values evaluate to true.

> select colA from table1 where colB > x AND colB <> y;

<expr1> OR <expr2>

Returns true if any of the values evaluate to true.

> select colA from table1 where colB > x OR colB = null;

NOT <expr>

Returns true if the value is false.

> select colA from table1 where colB NOT y;

The following truth table demonstrates the boolean output of AND and OR:

a	b	a AND b	a OR b
true	true	true	true
true	false	false	true
false	true	false	true
false	false	false	false