oracle 分页查询

select t.* from ( 
select a.SaleID || ',' || c.fid as ids,c.fileurl,rownum rw
                from B_CO_SALECONTRACT a 
                join  RM_CO_SALECONTRACTCONTENT b 
                on a.fid = b.fcontractid 
                join rm_co_salecontractdetail c 
                on b.fid = c.fid 
                where  c.fileurl is not null 
                and (status = '00' or status = '02' or status = '03')
                order by c.fid)t  where t.rw BETWEEN 10 AND 20;