/*
  col1 col2 결과값
  ---- ---- --------
  10   2    2
  20   10   8
  30   15   5
  40   17   2
*/
WITH t1 AS (
SELECT '10' AS col1, 2 AS col2 FROM dual UNION all
SELECT '20', 10 FROM dual UNION ALL
SELECT '30', 15 FROM dual UNION ALL
SELECT '40', 17 FROM dual
)
SELECT col1, col2, SUM(col1) OVER(ORDER BY col1)
 FROM t1
;

처음 던지는 질문입니다. 도움요청 드립니다.