select *, ROW_NUMBER() OVER (Order by id) as rownum from customersellerWITH tableAlias (Item, RN)AS ( SELECT FirstName, RN = ROW_NUMBER() OVER (ORDER BY CustomerID DESC) FROM dbo.Customer) select * from tableAlias where RN = 3