SELECT *FROM ( select zwxm00,pysm00,wbsm00,ygbh00,xkh000 from VW_BQ_ZGYS_YDHL where 1=1  and UPPER(XTDM00) ='MC' AND BMBH00 = 563 and ((PYSM00  like 'zll%')  OR (YGBH00  like 'zll%') )) WHERE ROWNUM<=100