[ORACLE] 누적합

-- ORACLE 누적합 ( 집계 함수의 윈도우 옵션 )

WITH TA AS 

(             SELECT 1 IDX, 1 VAL FROM DUAL 

    UNION ALL SELECT 2 IDX, 2 VAL FROM DUAL 

    UNION ALL SELECT 3 IDX, 3 VAL FROM DUAL 

    UNION ALL SELECT 4 IDX, 4 VAL FROM DUAL 

)

SELECT 

    IDX

  , VAL

  , SUM ( VAL ) 

    OVER ( ORDER BY IDX ASC

           RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING ) "SUM_ASC"

  , SUM ( VAL ) 

    OVER ( ORDER BY IDX DESC 

           RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING ) "SUM_DESC"

FROM TA

ORDER BY IDX ASC