SELECT *
  FROM (SELECT ROWNUM rownum1, c.*
          FROM (SELECT   b.ypmc00, a.ypzsl0, a.ypje00, b.ypgg00, a.ddd000,D.BMMC00
                    FROM (SELECT   ypnm00, SUM (ypzsl0) ypzsl0,
                                   SUM (ypje00) ypje00, SUM (ddd000) ddd000,zyid00,kdks00
                              FROM (SELECT   ypnm00, SUM (ypzsl0) ypzsl0,
                                             SUM (ROUND (lsdj00 * ypzsl0, 2)
                                                 ) ypje00,
                                             SUM (ROUND (  ypzsl0
                                                         * zhl000
                                                         / ddd000,
                                                         2
                                                        )
                                                 ) ddd000,zyid00,kdks00
                                        FROM vw_yk_kssjb0_zy
                                       WHERE fyrq00 between :开始时间 and ：截止时间 
                                       and   kdks00=:科室 
                                    GROUP BY ypnm00,zyid00,kdks00)
                          GROUP BY ypnm00,zyid00,kdks00) a,
                         bm_yd0000 b,BM_BMBM00 D,zy_brxxb0 N
                   WHERE a.ypnm00 = b.ypnm00  AND a.zyid00=N.zyid00 AND a.kdks00=d.bmbh00 
                ORDER BY ypje00 DESC) c)
 WHERE rownum1 >= 1 AND rownum1 <= 10