SQL Server 分页

select top "+pageSize+" * from Table where id not in (select top "+(currentPage - 1) * pageSize +" id from Table order by id desc) order by id desc

50~40 40~30 30~20 20~10 10~0

取30~20，先把50~30的去掉再取出前10