LIMIT and SLIMIT clauses

SELECT "water_level","location" FROM "h2o_feet" LIMIT 3

Output:

The query returns the three oldest points, determined by timestamp, from the h2o_feet measurement.

SELECT MEAN("water_level") FROM "h2o_feet" WHERE time >= '2019-08-18T00:00:00Z' AND time <= '2019-08-18T00:42:00Z' GROUP BY *,time(12m) LIMIT 2

Output:

This query uses the InfluxQL MEAN() function and a GROUP BY clause to calculate the average water_level for each tag and for each 12-minute interval in the queried time range. LIMIT 2 requests the two oldest 12-minute averages (determined by timestamp).

Note that without LIMIT 2, the query would return four points per series; one for each 12-minute interval in the queried time range.

SELECT "water_level" FROM "h2o_feet" GROUP BY * SLIMIT 1

Output:

The results above include only the first few rows, as the data set is quite large. The query returns all water_level points from one of the series associated with the h2o_feet measurement.

SELECT MEAN("water_level") FROM "h2o_feet" WHERE time >= '2019-08-18T00:00:00Z' AND time <= '2019-08-18T00:42:00Z' GROUP BY *,time(12m) SLIMIT 1

Output:

The query uses the InfluxQL MEAN() function and a time interval in the GROUP BY clause to calculate the average water_level for each 12-minute interval in the queried time range.

SLIMIT 1 requests a single series associated with the h2o_feet measurement.

Note that without SLIMIT 1, the query would return results for the two series associated with the h2o_feet measurement: location=coyote_creek and location=santa_monica.

SELECT "water_level" FROM "h2o_feet" GROUP BY * LIMIT 3 SLIMIT 1

Output:

The query returns the three oldest points, determined by timestamp, from one of the series associated with the measurement h2o_feet.

SELECT MEAN("water_level") FROM "h2o_feet" WHERE time >= '2019-08-18T00:00:00Z' AND time <= '2019-08-18T00:42:00Z' GROUP BY *,time(12m) LIMIT 2 SLIMIT 1

Output:

The query uses the InfluxQL function MEAN() and a time interval in the GROUP BY clause to calculate the average water_level for each 12-minute interval in the queried time range. LIMIT 2 requests the two oldest 12-minute averages (determined by timestamp) and SLIMIT 1 requests a single series associated with the h2o_feet measurement.

Note that without LIMIT 2 SLIMIT 1, the query would return four points for each of the two series associated with the h2o_feet measurement.