SELECT ROW_NUMBER() OVER (ORDER BY ProductID)
AS [Row Number],
SalesOrderDetailID AS [Detail ID], ProductID
FROM Sales.SalesOrderDetail
ORDER BY SalesOrderDetailID
a
b
c
d
