查找30和40条之间的记录解决办法

查找30和40条之间的记录
如题   谢谢

[解决办法]
select top 10 *
from (select top 40 * from table order by id) t
order by id desc