This blog show how to use the TOP keyword with the select statement. Top is used for getting the first n number of rows as per the user request.
Syntax
Select TOP n Columns
From Table
Where Condition
Example
Select top 10 empname
From Emptable
Where EmpSal > 1000