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 ...