新增：
 Select * from (select xmmc00,gjbm00,pysm00,wbsm00,sfxmid,sfje00,sfsx00,sfxx00,gg0000,DW0000,BH0000,jsxm00,YBLBMC,ZFBL00,BKEH83,GJBZMC,XYFW00,GGBZTS from VW_SS_YBFY00_INP where (pysm00 Like '%%') and(    ((ybbrlb='5571' and FBBH00='3' and YBZXLB='1' and sfsfxm='Y') or (sfsfxm='N'))  )  Order By pysm00) where Rownum<=100



修改：
SELECT *
  FROM (SELECT XMMC00,
               GJBM00,
               PYSM00,
               WBSM00,
               SFXMID,
               SFJE00,
               SFSX00,
               SFXX00,
               GG0000,
               DW0000,
               BH0000,
               JSXM00,
               YBLBMC,
               ZFBL00,
               BKEH83,
               GJBZMC,
               XYFW00,
               GGBZTS
          FROM VW_SS_YBFY00_INP
         WHERE (PYSM00 LIKE '%%')
         ORDER BY PYSM00)
 WHERE ROWNUM <= 100