勾选入院日期的情况下：
SELECT DISTINCT a.brid00,
                  a.zyid00,
                  a.zyh000,
                  a.mrn000,
                  a.rycwh0,
                  a.xm0000,
                  a.xb0000,
                  TO_DATE (a.ryrq00, 'YYYY.MM.DD') ryrq00,
                  a.rysj00,
                  TO_DATE (a.cyrq00, 'YYYY.MM.DD') cyrq00,
                  a.cysj00,
                  a.rzks00,
                  b.bmmc00 rzksmc,
                  c.zdmc00
    FROM zy_brxxb0 a, bm_bmbm00 b, bq_brzdxx c
   WHERE     a.rzks00 = b.bmbh00
         AND a.zyid00 = c.zyid00(+)
         AND a.ryrq00 BETWEEN '20180821' AND '20190121'
         AND a.xm0000 = '林希圣'
         AND ROWNUM <= 100
ORDER BY a.zyh000