Comparison operators

Timestream for LiveAnalytics supports the following comparison operators.

Operator	Description
<	Less than
>	Greater than
<=	Less than or equal to
>=	Greater than or equal to
=	Equal
<>	Not equal
!=	Not equal

Note

• The BETWEEN operator tests if a value is within a specified range. The syntax is as follows:

  BETWEEN min AND max

  The presence of NULL in a BETWEEN or NOT BETWEEN statement will result in the statement evaluating to NULL.

• IS NULL and IS NOT NULL operators test whether a value is null (undefined). Using NULL with IS NULL evaluates to true.

• In SQL, a NULL value signifies an unknown value.