Comparison operators - Amazon Timestream
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Timestream for LiveAnalytics will no longer be open to new customers starting June 20, 2025. If you would like to use Amazon Timestream for LiveAnalytics, sign up prior to that date. Existing customers can continue to use the service as normal. For more information, see Amazon Timestream for LiveAnalytics availability change.

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.