원하시는 결과가 아래와 같다면 grouping(name) 을 사용하시면
되지 않을까요?
/* ------------------------------ NAME WIFE SAL ------------------------------ ROBERT (null) 100 TIM MARY 80 [Total] 1 180 ------------------------------ */ WITH W_DATA(NO, NAME, WIFE, SAL) AS ( SELECT 1, 'ROBERT', NULL, 100 FROM DUAL UNION ALL SELECT 2, 'TIM', 'MARY', 80 FROM DUAL ) SELECT DECODE(GROUPING(NAME),0,NAME,'[Total]') AS NAME , DECODE(GROUPING(NAME),0,MAX(WIFE),COUNT(WIFE)) AS WIFE , SUM(SAL) AS SAL FROM W_DATA GROUP BY ROLLUP(NAME) ;