oracle多表联合查询怎么加分页

select * from (select ct.*,rownum rn from (select SUPP.adm_id id,SUPP.shop_name name,SUPP.img, 1 as pgfrom CT_admin_extend SUPPwhere SUPP.shop_name like '%锦江之星%'union allselect PRO.id,PRO.name,PRO.img,2 as pgfrom CT_supp_product PROwhere PRO.name like'%锦江之星%'union allselect HD.id,HD.name,HD.img,3 as pgfrom CT_supp_coupon HDwhere HD.name like'%锦江之星%'order by id) ct)where rn between 1 and 20你要这个？