In SQL Server TOP keyword is use get top n number of record in a controlled result.
Let consider below list of student with there class, marks, city and contact details.
Select top 5 student data.
Example
Output
Note : While using TOP we have to specify how many not of top record we need. In above example we specify that we need top 5 student record.
We can use the TOP keyword with ORDER BY clause. If We want to find out top 2 students who scores higher marks, and they belong from Pune city.
Let see below example.
Example
Output