Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,YPMC02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,CYL000,YPYFMC,ypmclb,MRYYZF,NBLBMC,NBZFBL,YPXZ00,XGCFZL,YPSYSM,Colour from VW_YS_YBFDMYPSR A where (PYSM00 Like '%') and( LBBH00 in ('2') AND YFBMBH=849 AND CFJB00 <= 3 AND GZDJ00 <= '3'  and KSSDJ0<='3'  and YBBRLB='0' and YBZXLB='1' and FBBH00=3 and (exists (select 1 from BM_TSBZB0 C WHERE C.YBZXLB='1' AND C.BH0000='000002000001' AND C.MLXZBZ IN ('0','2')) or exists (select 1 from BM_TSBZXM b, BM_TSBZB0 c where A.YBXMBH=B.XMBH00 AND B.BH0000=C.BH0000 AND B.YBZXLB=C.YBZXLB AND B.YBZXLB='1'  AND ( B.BH0000='000002000001' or ( exists (select 1 from VW_YS_TSBZB_GXYTNB L where L.BH0000='000002000001' )) )  AND C.MLXZBZ IN ('1','3'))) )  Order By PYSM00) where Rownum<=30