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