Documentation

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
  5

View example results

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

View example results


Was this page helpful?

Thank you for your feedback!


Linux Package Signing Key Rotation

All signed InfluxData Linux packages have been resigned with an updated key. If using Linux, you may need to update your package configuration to continue to download and verify InfluxData software packages.

For more information, see the Linux Package Signing Key Rotation blog post.

State of the InfluxDB Cloud (IOx) documentation

The new documentation for InfluxDB Cloud backed by InfluxDB IOx is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.

InfluxDB Cloud powered by IOx