WITH T AS ( SELECT '2016/01/02' 날짜, 5000 금액 FROM DUAL UNION ALL SELECT '2016/01/20', 7000 FROM DUAL UNION ALL SELECT '2016/02/10', 5000 FROM DUAL UNION ALL SELECT '2016/02/22', 5000 FROM DUAL ) SELECT CASE WHEN GROUPING(날짜) = 1 THEN '누계' ELSE 날짜 END 날짜1 , SUM(금액) 금액 FROM T GROUP BY SUBSTR(날짜, 1, 7), ROLLUP(날짜)