sort() function

The sort() function orders the records within each table. One output table is produced for each input table. The output tables will have the same schema as their corresponding input tables.

Sorting with null values

When sorting, null values will always be first. When desc: false, nulls are less than every other value. When desc: true, nulls are greater than every value.

sort(columns: ["_value"], desc: false)



List of columns by which to sort. Sort precedence is determined by list order (left to right). Default is ["_value"].


Sort results in descending order. Default is false.


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


The following example uses data provided by the sampledata package to show how sort() transforms data.

Sort values in ascending order

import "sampledata"
    |> sort()

View input and output

Sort values in descending order

import "sampledata"
    |> sort(desc: true)

View input and output

Sort by multiple columns

import "sampledata"
    |> sort(columns: ["tag", "_value"])

View input and output

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.