LIMIT clause
The LIMIT clause limits the number of rows returned by a query to a specified non-negative integer.
Syntax
SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] LIMIT <N>Examples
Limit results to a maximum of five rows
SELECT
"water_level","location", "time"
FROM
"h2o_feet"
LIMIT
5Sort and limit results
Use the ORDER BY and LIMIT clauses to first sort results by specified columns,
then limit the sorted results by a specified number.
SELECT
"water_level", "location", "time"
FROM
"h2o_feet"
ORDER BY
"water_level" DESC
LIMIT
3Was 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 Cloud Dedicated and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.