Compute with immediate previous row value derived

Database

Compute with immediate previous row value derived

Hi All,

I have the below data, wherein I want to compute 'Amount' data dynamically in a 'Select' statement as given below, here I want

to refer the previous row value, apply an equation, compute a new value store it, for the next row again the same process of referring the

previous computed value. I shouldn't use stored procedures in this scenario, that's the catch. Please help, thank you.

Date, Amount

2016-11-01, 1000 

2016-11-02, 1100 (10% of 1000 + 1000) + previous value

2016-11-03, 1210 (10% of 1100 + 1100) + previous value

2016-11-04, 1331 (10% of 1210 + 1210) + previous value