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,ghid00
                              FROM (SELECT   ypnm00, SUM (ypzsl0) ypzsl0,
                                             SUM (ROUND (lsdj00 * ypzsl0, 2)
                                                 ) ypje00,
                                             SUM (ROUND (  ypzsl0
                                                         * zhl000
                                                         / ddd000,
                                                         2
                                                        )
                                                 ) ddd000,ghid00
                                        FROM vw_yk_kssjb0_mz
                                       WHERE fyrq00 ='20120910' 
                                    GROUP BY ypnm00,ghid00)
                          GROUP BY ypnm00,ghid00) a,
                         bm_yd0000 b,BM_BMBM00 D,SF_BRXXB0 N
                   WHERE a.ypnm00 = b.ypnm00 AND a.ghid00=N.ghid00 AND N.jzks00=d.bmbh00 and bmmc00=:¿ÆÊÒ
                ORDER BY ddd000 DESC) c)
 WHERE rownum1 >= 1 AND rownum1 <= 10