Question

select top 10 * from (select top 40 * from a order by id asc

Answer 1

这个语句第一部分

(select top 40 * from a order by id asc) top_n

查出前40条数据,表的别名为 top_n

再 order by id desc逆序查询出前10条,

也就是40到31条

所以就能取到结果

若还有疑问请直接HI我.