take operator
Learn how to use the take operator to return a specified number of rows.
Return up to the specified number of rows.
There is no guarantee which records are returned, unless the source data is sorted. If the data is sorted, then the top values will be returned.
Syntax
take NumberOfRows
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| NumberOfRows | int | ✔️ | The number of rows to return. |
Paging of query results
Methods for implementing paging include:
- Export the result of a query to an external storage and paging through the generated data.
- Write a middle-tier application that provides a stateful paging API by caching the results of a Kusto query.
- Use pagination in Stored query results
Example
StormEvents | take 5
Related content
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.