SELECT CASE WHEN TOT_DEPT_NM = LAG(TOT_DEPT_NM) OVER(ORDER BY ROWNUM) THEN NULL
            ELSE TOT_DEPT_NM
       END  TOT_DEPT_NM
     , DEPT_NM
     , BASE_AMT
     , SUK_AMT
     , BAN_AMT
     , FAM_AMT
     , TONG_AMT
     , FOOD_AMT
FROM  (
        SELECT DECODE(GROUPING(TOT_DEPT_NM),1,'총 합계', TOT_DEPT_NM) TOT_DEPT_NM,
               DECODE(GROUPING(DEPT_NM),1,'합계', DEPT_NM) DEPT_NM,
               SUM(BASE_AMT) "BASE_AMT",
               SUM(SUK_AMT) "SUK_AMT",
               SUM(BAN_AMT) "BAN_AMT",
               SUM(FAM_AMT) "FAM_AMT",
               SUM(TONG_AMT) "TONG_AMT",
               SUM(FOOD_AMT) "FOOD_AMT"
        FROM HRMS.HDSA_BASE_VIEW_D
        GROUP BY ROLLUP(TOT_DEPT_NM, DEPT_NM)
      )
 

SELECT DECODE(1, GROUPING(tot_dept_nm), '총 합계'
               , RANK() OVER(PARTITION BY tot_dept_nm ORDER BY dept_nm)
               , tot_dept_nm) tot_dept_nm

답글 달아주신 두분께 감사드립니다.

많은 도움되었습니다.