Oracle分页语句

例子:

 

select name from

                         (

                           select name,rownum r

                                                           (

                                                                   select name from head order by name where.....

                                                           )

                         )

where r>=5 and r<=10

评论

2 楼 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

1 楼 spiritfrog 2008-06-20  

你这样就能分页了？不用求记录总数的吗？