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.