Selecting the Top Records from the SQL Server without using the TOP keyword

Devesh Omar
11y
11.5k
0
0
25
Blog

We would like to use the CTE for this purpose.

Consider the following table Emp :

1. Column : Empname varchar(30)
2. Column : CreateDdate datetime

WITH CTE AS (
    SELECT Empname , rowno = row_number() OVER(ORDER BY CreateDdate )
    FROM Emp
)
SELECT *
FROM   CTE
WHERE rowno BETWEEN 1 AND 5

This way we can use the CTE for selecting the Top keywords.