Where

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

• Syntax
• Examples

Syntax

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

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

Examples

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

Filter data based on field values

SELECT * 
FROM "h2o_feet" 
WHERE "water_level" >= 9.78

{{< expand-wrapper >}} {{% expand "View example results" %}}

The query returns data from the h2o_feet measurement with water_level field values that are greater than or equal to 9.78.

{{% /expand %}} {{< /expand-wrapper >}}

Filter data based on specific tag and field values

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

{{< expand-wrapper >}} {{% expand "View example results" %}}

The query returns all data from the h2o_feet measurement with the location tag key, santa_monica, and a level description field value that equals below 3 feet.

{{% /expand %}} {{< /expand-wrapper >}}

Filter data within a specific time period

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

{{< expand-wrapper >}} {{% expand "View example results" %}}

The query returns results with timestamps greater than or equal to 08-19-2019T12:00:00Z and less than or equal to 08-19-2019T13:00:00Z.

{{% /expand %}} {{< /expand-wrapper >}}

Filter data by dynamic date ranges

Use date and time functions to filter data by relative time periods that automatically update.

Get data from yesterday

SELECT *
FROM h2o_feet 
WHERE "location" = 'santa_monica'
  AND time >= DATE_TRUNC('day', NOW() - INTERVAL '1 day') 
  AND time < DATE_TRUNC('day', NOW())

{{< expand-wrapper >}} {{% expand "View example results" %}}

This query filters data to include only records from the previous calendar day:

• NOW() - INTERVAL '1 day' calculates yesterday's timestamp
• DATE_TRUNC('day', ...) truncates to the start of that day (00:00:00)
• The range spans from yesterday at 00:00:00 to today at 00:00:00

{{% /expand %}} {{< /expand-wrapper >}}

Get data from the last 24 hours

SELECT *
FROM h2o_feet 
WHERE time >= NOW() - INTERVAL '1 day' AND location = 'santa_monica'

{{< expand-wrapper >}} {{% expand "View example results" %}}

This query returns data from exactly 24 hours before the current time. Unlike the "yesterday" example, this creates a rolling 24-hour window that moves with the current time.

{{% /expand %}} {{< /expand-wrapper >}}

Get data from the current week

SELECT *
FROM h2o_feet 
WHERE time >= DATE_TRUNC('week', NOW()) AND location = 'santa_monica'

{{< expand-wrapper >}} {{% expand "View example results" %}}

This query returns all data from the start of the current week (Monday at 00:00:00) to the current time. The DATE_TRUNC('week', NOW()) function truncates the current timestamp to the beginning of the week.

{{% /expand %}} {{< /expand-wrapper >}}

Filter data using the OR operator

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

{{< expand-wrapper >}} {{% expand "View example results" %}}

The query returns results with a level description field value equal to less than 3 feet or a water_level field value less than 2.5.

{{% /expand %}} {{< /expand-wrapper >}}