select *

from (select t.*, rownum rn

from (select t_e_id, t_e_name, t_e_tel, t_e_areacode

from (select t.eid t_e_id,

t.ename t_e_name,

t.etel t_e_tel,

t.areaid t_e_areacode,

t.biz_delete_time,

decode(areaid, '0730', '0', '1') orderseq

from vr_enterprise t

where t.eid not in (select eid from t_biz_erelation))

order by orderseq, biz_delete_time nulls last) t)m

where m.rn >= 1 and m.rn <25