MySQL和Oracle分页查询 MySQL: select * from tableName limit(curPage-1)*pageSize,pageSize; Oracle: select * from (select ROWNUM as rn, a.* from (SELECT * FROM tableName) a where ROWNUM <= {ENDCOUNT}) b where rn > {BEGINCOUNT}