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)
Parameters
n
(Required) Maximum number of records to output.
offset
Number of records to skip per table before limiting to n
.
Default is 0
.
tables
Input data.
Default is piped-forward data (<-
).
Examples
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
- Limit results to the first three rows in each input table after the first two
Limit results to the first three rows in each table
import "sampledata"
sampledata.int()
|> limit(n: 3)
Limit results to the first three rows in each input table after the first two
import "sampledata"
sampledata.int()
|> limit(n: 3, offset: 2)
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 Flux and this documentation. To find support, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.