Sql 从31排序到 40

Sql 从31排序到 40 并且ID不连续的情况：
select * from(select *,ROW_NUMBER() over(order by ID)as 'userID' from A) as a where a.userID between 31 and 40

要注意改方法只能使用与sql2005以后并且ROW_NUMBER() over(order by ID)必须排序

有先获取获取前40条数据并且按照倒叙的方式排列,在取其中的前十条

select top 10 * from (select top 40 ID from A order by ID) as a order by a.ID desc