ORDER BY clause
ORDER BY clause to sort data by time in ascending or descending order.
InfluxQL only supports sorting data by
SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] ORDER BY time [ASC|DESC]
- If the the
ORDER BYclause is not included, the default behavior is to sort data by time in ascending order:
ORDER BY time ASC.
- If the query includes
GROUP BYclauses, the
ORDER BYclause must come after these clauses.
- ASC (ascending): The first row in the results has the oldest timestamp. The last row in the results has the most recent timestamp.
- DESC (descending): The first row in the results has the most recent timestamp. The last row in the results has the oldest timestamp.
The following examples use the Get started home sensor sample data.
Sort data with the oldest points first
Sort data with the newest points first
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.