选择查询特定行数，分页

查询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@