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).

🚧

ORDER BY Limit

For ChaosSearch operations, ORDER BY requires a LIMIT clause with a maximum value of 1000.

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;