select * from ( select ROWNUM as rowno, tt.* from ( 
select a.ZLXMJC, a.DW0000, a.SFJE00, null as LBBHMC, null as YDBZ00 , a.PYSM00, a.ZLXMID, a.SFBZDJ 
from vw_yj_ybfyyz_djbz a where a.zlxmbh like 'Z%' and SFYXSQ = 'Y' and SFBZDJ = '0'
 and ((ybbrlb = '0' and ybzxlb = '0' and fbbh00 = '1' and sfsfxm = 'Y') or sfsfxm = 'N') 
and MZZYBZ <> '1' and a.Zlxmid >= 100 and rownum <= '100' order by a.zlxmbh ) tt where ROWNUM <= 100 )