T SQL - How to get row numbers from select query

Post date: Aug 27, 2009 8:23:58 AM

select *, ROW_NUMBER() OVER (Order by id) as rownum from customers

eller

WITH tableAlias (Item, RN)

AS

( SELECT

FirstName,

RN = ROW_NUMBER() OVER (ORDER BY CustomerID DESC)

FROM dbo.Customer

)

select * from tableAlias where RN = 3