本文共 304 字,大约阅读时间需要 1 分钟。
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
转载地址:http://jhzli.baihongyu.com/