select * from (select *,ROW_NUMBER()over(order by [ID]) as rowindex from product ) tb where rowindex between " + ((pageIndex - 1) * pageSize + 1) + " and " + pageIndex * pageSize
--关键语句:--
ROW_NUMBER()over(order by [ID]) as rowindex
select * from (select *,ROW_NUMBER()over(order by [ID]) as rowindex from product ) tb where rowindex between " + ((pageIndex - 1) * pageSize + 1) + " and " + pageIndex * pageSize
--关键语句:--
ROW_NUMBER()over(order by [ID]) as rowindex
转载于:https://www.cnblogs.com/lgq880821/p/11510946.html