分页的区别,MySQL 和Oracle,sqlServer
mysql 常用的分页方式:(1)limit分页公式:curPage是当前第几页;pageSize是一页多少条记录
select * from dual where 1=1 limit (curPage-1)*pageSize,pageSize
Oracle 常用的分页方式:
select *
from(select d.*,row_number() over(order by d.BIRTHDAY) as rownumber
from DONORINFO d
WHERE d.BIRTHDAY BETWEEN TO_DATE ('19800101', 'yyyymmdd')
AND TO_DATE ('20060731', 'yyyymmdd')
) p
where p.rownumber BETWEEN size*(page-1)+1 AND page*size;
sqlserver 常用的分页方式:
select top pageSize, o.* from ( select row_number() over(order by orderColumn) as rownumber,* from(sql) as o where rownumber>firstIndex;