WHERE clause

Use the WHERE clause to filter results based on fields, tags, or timestamps.


SELECT_clause FROM_clause WHERE <conditional_expression> [(AND|OR) <conditional_expression> [...]]

Note: Unlike InfluxQL, SQL supports OR in the WHERE clause to specify multiple conditions, including time ranges.


Note that single quotes are required for string literals in the WHERE clause.

Filter data based on field values

FROM "h2o_feet" 
WHERE "water_level" >= 9.78

View example results

Filter data based on specific tag and field values

FROM "h2o_feet" 
WHERE "location" = 'santa_monica' and "level description" = 'below 3 feet' 

View example results

Filter data within a specific time period

FROM h2o_feet 
WHERE "location" = 'santa_monica'
AND "time" >= '2019-08-19T12:00:00Z'::timestamp AND "time" <= '2019-08-19T13:00:00Z'::timestamp 

View example results

Filter data using the OR operator

FROM "h2o_feet"
WHERE "level description" = 'less than 3 feet' OR "water_level" < 2.5

View example results

Was this page helpful?

Thank you for your feedback!

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.

InfluxDB Cloud Serverless powered by IOx