with #pager as
(
select * ,ROW_NUMBER() OVER(Order By ID) as rowid from table
)
select * from #pager where rowid between (130 * (50-1)+1) and 130 * 50 --50条/页,第130页
with #pager as
(
select * ,ROW_NUMBER() OVER(Order By ID) as rowid from table
)
select * from #pager where rowid between (130 * (50-1)+1) and 130 * 50 --50条/页,第130页