top operator
Learn how to use the top operator to return the first specified number of records sorted by the specified column.
Returns the first N records sorted by the specified column.
Syntax
T | top NumberOfRows by Expression [asc | desc] [nulls first | nulls last]
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string | ✔️ | The tabular input to sort. |
| NumberOfRows | int | ✔️ | The number of rows of T to return. |
| Expression | string | ✔️ | The scalar expression by which to sort. |
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. |
Example
Show top three 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 | … |
Related content
- Use top-nested operator to produce hierarchical (nested) top results.
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.