Select nth Row from Table in SQL Server

DECLARE @RowNumber INT = 9

WITH TableWithRow AS

(

      SELECT

       (ROW_NUMBER() OVER(ORDER BY employees.EmployeeID)) as ROW,

       FirstName,LastName         

      FROM employees

)

SELECT * FROM TableWithRow WHERE ROW = @RowNumber

Output:

ROW                  FirstName  LastName
-------------------- ---------- --------------------
9                    Ashvin     Padhiyar

(1 row(s) affected) 

Note: ROW_NUMBER() is an analytic function. It assigns a unique number to each row to which it is applied, in the ordered sequence of rows specified in the order_by_clause, beginning with 1.