SELECT *
  FROM (select xmmc00, bh0000, pysm00, wbsm00, sfje00, sfxmid
          from VW_BQ_YBSFXM
         where 1 = 1
           and YBZXLB = '@'
           and Ybbrlb = '1'
           and fbbh00 = '1'
           and (KSBMBH = 171or ksBMBH is null)
           and sfbzdj = '0'
           and (pysm00 like '%jrzs%')
         ORDER BY BH0000, PYSM00
         )
 WHERE ROWNUM <= 1000