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 aBETWEEN
orNOT BETWEEN
statement will result in the statement evaluating toNULL
. -
IS NULL
andIS NOT NULL
operators test whether a value is null (undefined). UsingNULL
withIS NULL
evaluates to true. -
In SQL, a
NULL
value signifies an unknown value.