SQL分页
select * from (select ROW_NUMBER() over(order by id desc) as row,* from Article) t
where t.row between 3 and 33
with temptbl as (
select ROW_NUMBER() over(order by id desc) as row,* from Article
)
select * from temptbl where row between 55 and 66
select top 10 * from Article where id not in
(
select top (2-1)10 id from Article order by id desc
)
order by id desc