oracle数据库在排序后分页需要3层select from

oracle_pagination.sql

select OuterWrap.*
from (
    SELECT ROWNUM as AfterOrderRowNum,  Wrap.*
    FROM (
        SELECT  "RechargeOrder"."CREATE_TIME" AS "RechargeOrder_CREATE_TIME" ,
               ROWNUM AS "BeforeOrderRowNum"
        FROM "T_RECHARGE_ORDER" "RechargeOrder"
        ORDER BY "RechargeOrder"."CREATE_TIME" DESC
        ) Wrap

    where ROWNUM < 100
    ) OuterWrap
where AfterOrderRowNum >= 5