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

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