sql分页语句 速度比较快 

select * from (
    select *,ROW_NUMBER() over (order by createtime) as rank from taskInfo
)as t where t.rank between 6 and 10

 

posted @ 2013-11-04 16:27  梦醒心晴  Views(329)  Comments(0)  Edit  收藏  举报