select * from (select ypmc00,ypsx00,pysm00,wbsm00,ypgg00,ypbm00,ypnm00,lsjxx0,sjkcxx,zfbl00,yblbmc,colour,lbbh00,bqkdyf,ybzxlb,ybbrlb,ypmclb,ypsysm,ypxzmc,nblbmc,nbzfbl,bz0000,yfbmbh,kssjb0,ypmc02,dxsybz from VW_BQ_FBYP00_DZBL where 1 = 1 and () and kssjb0<1 and ( upper(PYSM00) like '%') Order by PYSM00)where rownum <= 133