SELECT m.*
  FROM (SELECT a.*,
               ROW_NUMBER () OVER (PARTITION BY a.yjdjh0 ORDER BY yjdjh0) xh
          FROM (SELECT DISTINCT a.yjdjh0, a.zyghid zyid00, a.brxm00, a.xb0000,
                                a.nl0000,
                                DECODE (dyrqxx, 0, '´òÓ¡', '²¹´ò') jbxx01,
                                jzbz00, zyhghh, a.kdbqmc, a.bbmc00,
                                TO_CHAR (SYSDATE, 'YYYY-MM-DDHH24:MI') dyrqsj,
                                zlxmjc, zxks00, kdys00, kdysxm, rycwh0 ch0000,
                                a.sl0000, kdksmc, dyczy0, dyczxm
                           FROM vw_jy_brxxtmdyd a
                          WHERE 1 = 1
                            AND NVL (dyrqxx, '0') <> '0'
                            AND kdrq00 BETWEEN '20160602' AND '20160606'
                            AND kdrq00 || kdsj00 BETWEEN '2016060200:00:00'
                                                     AND '2016060623:59:59'
                            AND zyghid IN (2317165)) a,
               bm_bmbm00 b) m
 WHERE xh <= 2