ORDER BY Clause

The ORDER BY clause sorts a result set by one or more output expressions. Each expression may be composed of output columns or it may be an ordinal number selecting an output column by position (starting at one).

🚧

Note that ORDER BY requires a LIMIT clause for ChaosSearch operations or the query will fail. LIMIT currently requires an integer value and the maximum value is currently TBD in the range of 10,000 to 100,000.

Supported ordering and grouping syntax includes the following.

ORDER BY  {columns,...} [ ASC | DESC ] LIMIT <value> [, ...]

Example

SELECT "client_ip","response_processing_time" 
FROM "sample-elb-view"
ORDER BY "response_processing_time" desc LIMIT 100;