Sql paging in Oracle

select t.*
from (select t.*, row_number() over (order by t.aps_id desc) rn
      from pds_sales.tbl_all_pds_sales t) t
where t.rn > :first and t.rn <= :last