LIMIT clause
InfluxDB 3 Core is in Public Alpha
InfluxDB 3 Core is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
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
5
Sort 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
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 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.