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
SQL Server Transact Basic to Expert - Select Query with TOP
SQL Server Transact Basic to Expert - Select Query with TOP

Join the conversation! Your thoughts help the community grow.