mysql实现分页时,使用的是 limit startIndex,number
startIndex:其实位置
number: 页大小
在sqlserver中,可以用如下方式实现分页,但需要使用一个原表的一个字段进行排序。
可以这样:
select * from (select row_number() over(order by passportid ) as RN,* FROM dbo.alldata1 where 1=1 ) t where t.RN > (20) and t.RN<=30
passportid : 字段名
dbo.alldata1: 表名
20 和 30 是范围 ,转化为 startIndex,number可以用下
select {0} from (select row_number() over(order by {1} ) as RN,* FROM {2}) t where t.RN > {3} and t.RN <= {3} + {4}
oracle分页语句
SELECT {0} FROM (SELECT A.*, rownum oracle__r FROM (SELECT * FROM {1}) A WHERE rownum <= {2}+{3}) B WHERE oracle__r > {2}