查询11~20行的结果: select a.msgid from ( select rownumber() over(order by b.SendTime desc) as rownum,b.* from session.results b )as a where a.rownum>10 and rownum <=20@