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!


Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless 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 Serverless powered by IOx