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