SqlServer 分页语句

两种:

(1):

 

select top 20 name from table where id>
       (select max(id) from
                (select top 20*3 name from table order by id)
        )

 

(2) :
select top 20 name form table where id not in
  (select top 20*3 from table order by id)

评论

1 楼 laserdance 2008-12-19  

declare @pagesize int;
set @pagesize=20
declare @currentpage int
set @currentpage=3
print @currentpage
select * from
(   select TOP (@pagesize) * FROM
( SELECT TOP ((@currentpage)*(@pagesize))   * from ipaddressmappings   ORDER BY id ASC ) as aSysTable  
ORDER BY id DESC ) as bSysTable  
ORDER BY id ASC