LIMIT clause limits the number of rows returned by a query to a specified non-negative integer.
SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] LIMIT <N>
Limit results to a maximum of five rows
SELECT "water_level","location", "time" FROM "h2o_feet" LIMIT 5
Sort and limit results
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 3
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.