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 DESCSort data by tag or field values
SELECT
"water_level", "time", "location"
FROM
"h2o_feet"
ORDER BY
"location", "water_level" DESCSort data by selection order
SELECT
"location","water_level", "time"
FROM
"h2o_feet"
ORDER BY
1, 2Was 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 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.