Hi there

There is no equivalent. Here are some methods from other posters:

SELECT *

FROM

(

SELECT TOP 3000 *

FROM

)

SELECT TOP 5000 *

FROM table

ORDER BY key

) AS top5000

ORDER BY key DESC

) AS last3000

ORDER BY key

Alternatively you can use a temp table with an generated identity

column:

SELECT top5000.*,

rownum = IDENTITY (INT,1,1)

INTO #top5000

FROM

(

SELECT TOP 5000 *

FROM table

ORDER BY key

) AS top5000

SELECT *

FROM #top5000

WHERE rownum BETWEEN 2000 AND 5000

Also, have a good read of this:

http://groups.google.com/groups?oi=djq&selm=an_527662542

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"