oracle 分页

with tmp_ as
  (select us.userUuid, ub.invitationid, us.loginid, ub.createtime, ub.state
     from UserAutoUnitBuyInvitation ub, UserSpace us
    where us.useruuid = ub.invituseruuid
      and ub.useruuid = '4d85cc1b-7580-4663-8983-d5638dc1efa9'
      and ub.gameid = 'sfc' or (ub.state ='0' and ub.state ='1')
    order by ub.createtime desc)
 select invitationid, userUuid, loginid, createtime, state
   from (select ROWNUM RNUM,
                userUuid,
                invitationid,
                loginid,
                createtime,
                state
           from tmp_)
  where RNUM > 0
    and RNUM <= 0 + 5
  order by RNUM