I have a query for which I would like to add the following column (they are all Doubles):
column1 column2 - this it the column I want to add
value1 x1 = value1 from column1, the same number
value2 x2 = x1 + 0.1*x1 + value2
value3 x3 = x2 + 0.1*x2 + value3
value4 x4 = x3 + 0.1*x3 + value4
value5 x5 = x4 + 0.1*x4 + value5
and so on..
I suppose I either need a function or use some subqueries. Thank you.