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