如何将上一行值添加到下一行？

我有桌子像



id credit



1 1000



2 2000



3 3000



i需要一个结果集以下



id贷方余额



1 1000 1000



2 2000 3000



3 3000 6000





我试过这个查询



选择t1.id，t1.credit），t1.credit + t2.credit，来自table1 t1内部JOIN table1 t2 ON t1 .ID = t2.id - 1

I have table like

id credit

1 1000

2 2000

3 3000

i need a result set like the below

id credit balance

1 1000 1000

2 2000 3000

3 3000 6000


I tried with this query

Select t1.id ,t1.credit),t1.credit+t2.credit, from table1 t1 Inner JOIN table1 t2 ON t1.ID = t2.id - 1