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