/*
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
;
처음 던지는 질문입니다. 도움요청 드립니다. |