MS SQL Equivalent to MySQL limit 15,10

[Anon]

OK I have read quite a bit of comparisons to the MSSQL commands: TOP or ROWCOUNT to achieve what MySQL does with limit X

BUT ...what happens when we use LIMIT X, X A good example is: limit 15, 10 where we get a result set of 10 rows STARTING WITH ROW 15!

That simple little wonder of MySQL appears to be missing in MSSQL. Is it possible to easily return 10 rows starting with row X in MSSQL? -If you know please fill me in. I have searched all over phpbuilder and come up empty.

Thanks,
-Chris

[Anon]

select top 10 * from t where pk not in
(select top 15 pk from t order by pk)
order by pk

[Anon]

Didn't have it last I used it. Use subselect for this -

SELECT top 10 FROM (SELECT top 20
FROM blah ORDER BY blah_id DESC)
ORDER BY blah_id;