The $top system query option specifies that only the first n records should be returned
Example:
get Item?$top=5&$skip=0&orderby=ItemCode
Returns only the first five Items.
Attention
This query option only works together with the $skip and $orderby query options.
ODATA $skip and $top commands, web page handling and $inlinecount command
This option is useful when, for example page x from y is required.
Create a statement with $top=x, but the complete count of rows is also required, for which $inlinecount can be used.
The $inlinecount command produces two SQL statements:
1.select count(*) for the count property
2.select top x for the values