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