Tabular Operators
top
Learn how to return the first N records grouped by the specified columns from your query.
Returns the first N records grouped by the specified columns.
Syntax
Arguments
| name | type | description |
|---|---|---|
| Number Of Rows | integer | The number of rows of dataset to return. You can specify any numeric expression. |
| Expression | string | A scalar expression by which to sort. The type of the values must be numeric, date, time, or string. |
| asc or desc | value | (the default) may appear to control whether selection is actually from the “bottom” or “top” of the range. |
Where:
asc: ascending.desc: descending.