ORDER BY clause
The ORDER BY clause sort results by specified columns and order.
Sort data based on fields, tags, and timestamps.
The following orders are supported:
Syntax
[SELECT CLAUSE] [FROM CLAUSE] [ ORDER BY expression [ ASC | DESC ][, …] ]
Note: If your query includes a GROUP BY clause, the ORDER BY clause must appear after the GROUP BY clause.
Examples
Sort data by time with the most recent first
SELECT
"water_level", "time"
FROM
"h2o_feet"
WHERE
"location" = 'coyote_creek'
ORDER BY
time DESC
Sort data by tag or field values
SELECT
"water_level", "time", "location"
FROM
"h2o_feet"
ORDER BY
"location", "water_level" DESC
Sort data by selection order
SELECT
"location","water_level", "time"
FROM
"h2o_feet"
ORDER BY
1, 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 InfluxDB and this documentation. To find support, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.