Oracle 分页，根据伪列ROWNUM分页

@Select("SELECT * FROM (SELECT *,ROWNUM AS N FROM (${sql}) R WHERE ROWNUM <=${pageNum}*${pageSize} ) RES WHERE RES.N_>(CASE WHEN ${pageNum}<=1 THEN 0 ELSE (${pageNum}-1)*${pageSize} END)")
List<Map> commonQueryByPage(@Param("sql") String sql,@Param("pageNum") int pageNum,@Param("pageSize") int pageSize);

Oracle 分页，根据伪列ROWNUM分页

原文：https://www.cnblogs.com/shihx/p/12048277.html