db2、mysql、oracle的分页查询

DB2：

SELECT * FROM (Select field1,field2,field3,rownumber() over(ORDER BY field4 ASC) AS rn from 表名) AS a1

WHERE a1.rn BETWEEN startIndex AND endIndex 

Mysql：

select   *   from   table   limit   start,pageNum 

ORACLE：

select * from (select rownum,name from table where rownum <=endIndex )   where rownum > startIndex