Three Ways to Limit Your Results in SQL Server 2016

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;