几种常用数据库（SQLServer Oracle db2 mysql等）分页SQL的写法总结

1、Sql server （2005或以上版本）、oracle、mysql

select * from (select row_number()  over (order by ...) as rn from ...) as data where rn>0 and rn<=10

2、db2

select * from (select rownumber()  over (order by ...) as rn from ...) as data where rn>0 and rn<=10

3、Infomix

select skip 0 first 10 * from ...

欢迎访问：http://121.18.78.216 适易查询分析、工作流、内容管理及项目管理演示平台