SQL Server Transact Basic to Expert - Select Query with TOP

SQL Server Transact Basic to Expert - Select Query with TOP

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