Oracle - 순차적으로 누적하기0

[ Oracle - 순차적으로 누적하기0 ]

 

WITH t AS ( SELECT '20120101' DT, 1 seq, 100 amt, 10 stdAmt FROM dual UNION ALL SELECT '20120102', 1, 200, 0 FROM dual UNION ALL SELECT '20120103', 1, 300, 0 FROM dual UNION ALL SELECT '20120104', 1,400, 0 FROM dual UNION ALL SELECT '20120105', 1,500, 0 FROM dual UNION ALL SELECT '20120106', 1,600, 0 FROM dual UNION ALL SELECT '20120107', 1,700, 0 FROM dual UNION ALL SELECT '20120101', 2, 100, 10 FROM dual UNION ALL SELECT '20120102', 2, 200, 0 FROM dual UNION ALL SELECT '20120103', 2, 300, 0 FROM dual UNION ALL SELECT '20120104', 2, 400, 0 FROM dual UNION ALL SELECT '20120105', 2, 500, 0 FROM dual UNION ALL SELECT '20120106', 2, 600, 0 FROM dual UNION ALL SELECT '20120107', 2, 700, 0 FROM dual ) SELECT DT , SEQ , amt , stdAmt , SUM(amt+stdAmt) OVER (PARTITION BY SEQ ORDER BY DT) sum_amt FROM t