Select * from (select xmmc00,zfbl00,ypjx00,YPGG00,XMBH00,YBBRLB,PYSM00,WBSM00,ybbz00,SCCJ00,YBJSDJ,YPSM00 from VW_BM_YBSFXM_YPMCYY where (XMBH00 Like ?) and( (FBBH00=3) and (sfyx00='Y') and ybzxlb='4' and ypnm00=47761 )  Order By Instrb(XMBH00,'10403028157842530601'),XMBH00) where Rownum<=200