MySQL Dynamic Total Value

Vote count:

0

Price Table:

date       | price
------------------
2014-01-01   100
2014-01-02   20
2014-01-03   -30
2014-01-04   70
...

Is it possible to show a result table with a SQL query?

Result table:

date       | price  | total
--------------------------
2014-01-01   100     100
2014-01-02   20      120
2014-01-03   -30     90
2014-01-04   70      160
...

1. "Result table" is not an exist table its just sql result


2. "total" column should show the last status of customer's balance with addition and subtraction with previous row

Is it possible to write this SQL query?

asked 12 secs ago

Kumul

40