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
pl/sql 分页语句
最新推荐文章于 2021-09-18 09:59:14 发布