Select top records without using TOP keyword

[deveshakgec]

Here we are using CTE

WITH CTE AS (
   SELECT Col1, rowno = row_number() OVER(ORDER BY Col2)
   FROM Table
   
)
SELECT *
FROM   CTE
WHERE  rowno BETWEEN 1 AND 5

[Rabbit]

Please use code tags when posting code or formatted data.

What is your question? You seem to have answered yourself.