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

View example results

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

View example results

Was this page helpful?

Thank you for your feedback!