Oracle分組統計小計放在最後一行的處理

      在做統計查詢，需要一個小計百分數放在最後一行，但不是最大最小的。處理過程如下記錄：

SELECT '工單' AS BILTYPENAME,
               CASE WHEN BUREAU_ID IS NULL THEN '小計'
               ELSE BUREAU_ID
               END AS BUREAU_ID,
               CASE WHEN BILLSERVER_ENNAME IS NULL AND BUREAU_ID IS NOT NULL 
                 THEN '小計'
                 ELSE BILLSERVER_ENNAME
               END AS BILLSERVER_ENNAME,
               SUM(TOTAL) AS TOTAL,
               SUM(SUCC_NUM) AS SUCCNUM,
               SUM(FAIL_NUM) AS FAILNUM,
               DECODE(SUM(SUCC_NUM) / SUM(TOTAL),NULL,'0',1,'100',
                    TO_CHAR(ROUND(SUM(SUCC_NUM) / SUM(TOTAL), 4) * 100
                        ,'fm90.00')) || '%' 
               AS SUCCESSRATE,
               DECODE(BILLSERVER_ENNAME, NULL, -1, 1) 
                   *ROUND(SUM(SUCC_NUM) / SUM(TOTAL), 4) AS PAIXU
          FROM APP_ORIGINBILL_STAT_DAY ORIGINBILLOBJ
         WHERE 1 = 1
         GROUP BY ROLLUP(BUREAU_ID, BILLSERVER_ENNAME)
         ORDER BY BUREAU_ID NULLS LAST, PAIXU DESC
           

 這裡百分數用 DECODE(SUM(SUCC_NUM) / SUM(TOTAL),NULL,'0',1,'100',

                    TO_CHAR(ROUND(SUM(SUCC_NUM) / SUM(TOTAL), 4) * 100 ,'fm90.00')) || '%'  來表示，這樣最後排序時，有可能小計位于中間位置，通過 PAIXU 字段  DECODE(BILLSERVER_ENNAME, NULL, -1, 1)

                   *ROUND(SUM(SUCC_NUM) / SUM(TOTAL), 4)  重新進行降序排序，可以真正實作如圖的排序。

 應該有更好的方法，希望能提供！