InfluxDB Clustered is currently only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.
HAVING clause places conditions on results created by an aggregate operation on groups.
HAVING clause must follow the
GROUP BY clause and precede the
ORDER BY clause.
WHERE clause filters rows based on specified conditions before the aggregate operation.
HAVING clause filters rows based on specified conditions after the aggregate operation has taken place.
SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [HAVING_clause] [ORDER_BY_clause]
Return rows with an aggregate value greater than a specified number
SELECT MEAN("water_level") AS "mean_water_level", "location" FROM "h2o_feet" GROUP BY "location" HAVING "mean_water_level" > 5
Return the average result greater than a specified number from a specific time range
SELECT AVG("water_level") AS "avg_water_level", "time" FROM "h2o_feet" WHERE time >= '2019-09-01T00:00:00Z' AND time <= '2019-09-02T00:00:00Z' GROUP BY "time" HAVING "avg_water_level" > 6.82 ORDER BY "time"
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.