TSQL - How to get row numbers for selected rows

Post date: Feb 14, 2010 11:47:05 AM

WITH Customer AS (SELECT *, ROW_NUMBER() OVER (ORDER BY CustomerID) AS RowNumber FROM cus_Customer )SELECT *FROM Customer WHERE RowNumber = 2