top operator

Returns the first N records sorted by the specified columns.

Syntax

T | top NumberOfRows by Expression [asc | desc] [nulls first | nulls last]

Parameters

Name Type Required Description
T tabular Input to sort.
NumberOfRows int The number of rows of T to return.
Expression string Scalar expression by which to sort. The type of the values must be numeric, date, time or string.
asc or desc string Controls whether the selection is from the "bottom" or "top" of the range. Default desc.
nulls first or nulls last string Controls whether null values appear at the "bottom" or "top" of the range. Default for asc is nulls first. Default for desc is nulls last.

Tip

top 5 by name is equivalent to the expression sort by name | take 5 both from semantic and performance perspectives.

Example

Show top 3 storms with most direct injuries.

StormEvents
| top 3 by InjuriesDirect

The below table shows only the relevant column. Run the query above to see more storm details for these events.

InjuriesDirect ...
519 ...
422 ...
200 ...

See also

  • Use top-nested operator to produce hierarchical (nested) top results.