HAVING clause
The HAVING clause places conditions on results created by an aggregate operation on groups.
The HAVING clause must follow the GROUP BY clause and precede the ORDER BY clause.
The WHERE clause filters rows based on specified conditions before the aggregate operation.
The HAVING clause filters rows based on specified conditions after the aggregate operation has taken place.
Syntax
SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [HAVING_clause] [ORDER_BY_clause]
Examples
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.