ORDER BY clause
InfluxDB 3 Enterprise is in Public Alpha
InfluxDB 3 Enterprise is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
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 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.