经典SQL分页语句

select top pageSize, * from (SELECT row_number() over(order by id desc) as rownumber,*
FROM tb1) A where rownumber > (pageIndex-1)*pageSize

posted on 2017-07-29 16:57  donchen-c  阅读(137)  评论(0编辑  收藏  举报