how to get nth rows from table

Hi,

 

 

 WITH myTableWithRows AS (
SELECT (ROW_NUMBER() OVER (ORDER BY TableColumnName)) as row,*
FROM TableName)
SELECT * FROM myTableWithRows WHERE row = 3

 

I think in your answer it should be equal to (=) instead of less than or equal to (<=)  because it will give you all rows less than or equal to n. If i am correct please update your answer.