Cacher is the code snippet organizer for pro developers

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