The query below uses TOP to select the TOP 3 students:
TOP
SELECT TOP 3 *
FROM Students;
The code below uses LIMIT to only show three records:
SELECT StudentName, StudentPercentage
FROM Students
LIMIT 3;
The query below uses RowNum to only show records 1 to 3
SELECT *
FROM Students
WHERE StudentPercentage 85 AND ROWNUM <= 3;