누적합 썸네일형 리스트형 [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 FOLLO.. 더보기 이전 1 다음