Add values from the previous row of one column to another column in current row

Viewed 2393

Hi I've a column in a table like this

Amount 
1
2
3
4
5
6
7

I want the result of my function or stored procedure to be something like this

output
--------

1
3
6
10
15
21
28

against the above column Please help me with a solution in this regard

1 Answers
Related