sort operator

Sort the rows of the input table into order by one or more columns.

Alias: order

Syntax

T | sort by column [asc | desc] [nulls first | nulls last] [, ...]

Name	Type	Required	Description
T	string	✓	Tabular input to sort.
column	string	✓	Column of T by which to sort. The type of the column values must be numeric, date, time or string.
`asc` or `desc`	string		`asc` sorts into ascending order, low to high. Default is `desc`, high to low.
`nulls first` or `nulls last`	string		`nulls first` will place the null values at the beginning and `nulls last` will place the null values at the end. Default for `asc` is `nulls first`. Default for `desc` is `nulls last`.

All rows in table Traces that have a specific ClientRequestId, sorted by their timestamp.

TraceLogs
| project ClientRequestId, Timestamp
| where ClientRequestId == "5a848f70-9996-eb17-15ed-21b8eb94bf0e"
| sort by Timestamp asc

The following table only shows the top 10 results. To see the full output, run the query.