SELECT TOP number of rows

Use the TOP clause to select the number of records from a result set. Use an integer to specify the number of rows in the result set. TOP PERCENT and TOP WITH TIES are not supported.

Syntax

SELECT TOP number_of_rows * FROM object