ORDER BY Clause
Sort SELECT results.
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 aLIMIT
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;

Updated 6 months ago