[query] 내역과 누적합계

-- 누적합
SELECT TRNS_AMT,
            SUM(TRNS_AMT) OVER(order by  ufnt_cdno) AS TRNS_SMAMT
FROM TB_INPH_PURS_LDGL_TRNS
;

-- 합계
SELECT TRNS_AMT,
            SUM(TRNS_AMT) OVER() AS TRNS_SMAMT
FROM TB_INPH_PURS_LDGL_TRNS
;