SELECT 기능 , NVL(서브기능, '합') 서브기능 , SUM(DECODE(팀, '3팀', 값)) "3팀" , SUM(DECODE(팀, '4팀', 값)) "4팀" , SUM(DECODE(팀, '5팀', 값)) "5팀" , SUM(DECODE(팀, '6팀', 값)) "6팀" , SUM(DECODE(팀, '7팀', 값)) "7팀" , SUM(DECODE(팀, '8팀', 값)) "8팀" , SUM(DECODE(팀, '9팀', 값)) "9팀" FROM 테이블 WHERE 조건 GROUP BY 기능, ROLLUP(서브기능) ORDER BY 기능, GROUPING(서브기능) DESC, 서브기능 ;