速度最快的分页

 select top 10 * from a  where id not in (select top (页数-1 )*10 id from a order by id desc ) order by id desc