在视图oracle中进行累计总和 [英] Make cumulative sum in view oracle

问题描述

我想在oracle中进行查看，如何获得我在本次快照中使用oracle所期望的'saldo'值?有人可以给我剧本吗?

I want to make a view in oracle, how can I get value of 'saldo' that I supposed like in this screenshoot with oracle? can someone give me the script?

我想要的结果:

dateacct   period_id   startdate   enddate     debit   credit   saldo
7/10/2015     1        1/10/2015   30/10/2015   25       0        25
8/10/2015     1        1/10/2015   30/10/2015   0        5        20
9/10/2015     1        1/10/2015   30/10/2015   0        3        17
10/10/2015    1        1/10/2015   30/10/2015   4        0        21

注意:dateacct，period_id，startdate，enddate，credit，debit是我从"akun"表中获取的列.

Notes: dateacct,period_id,startdate,enddate,credit,debit are the column that I take from 'akun' table.

推荐答案

尝试一下:

SELECT DATEACCT, PERIOD_ID, STARTDATE, ENDDATE, CREDIT, DEBIT,
    SUM (DEBIT-CREDIT) OVER (ORDER BY DATEACCT,PERIOD_ID,STARTDATE,ENDDATE) saldo
from AKUN
ORDER BY DATEACCT, PERIOD_ID, STARTDATE, ENDDATE;

这篇关于在视图oracle中进行累计总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！