Ordering commands
limit
Limits the number of returned records.
If you do not specify the limit, the query renders 1000 results (this limit, by default, is appended as the last line of the query).
You can increase or decrease the limit depending on your needs. Changing the limit has an impact on your DDU consumption and query execution time.
-
Syntax
| limit numberOfRqueryecords -
Example
1fetch logs2| limit 10
sort
Sorts the records. The default sorting order is descending. You can control the order in which your records are displayed by adding asc for ascending and desc for descending.
-
Syntax
| sort fieldname [asc | desc][, ...] -
Example
1fetch events2| sort timestamp desc, event.type asc