limit() function

The limit() function limits each output table to the first n records. The function produces one output table for each input table. Each output table contains the first n records after the offset. If the input table has less than offset + n records, limit() outputs all records after the offset. limit() is a selector function.

limit(n:10, offset: 0)



(Required) Maximum number of records to output.


Number of records to skip per table before limiting to n. Default is 0.


Input data. Default is piped-forward data (<-).


The following examples use data provided by the sampledata package to show how limit() transforms data.

Limit results to the first three rows in each table

import "sampledata"
    |> limit(n: 3)

View input and output

Limit results to the first three rows in each input table after the first two

import "sampledata"
    |> limit(n: 3, offset: 2)

View input and output

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.