Add Extra Column in Table with Cumulative values

Add Extra Column in Table with Cumulative values

saikalyan9981saikalyan9981 Posts: 10Questions: 3Answers: 0

Is there a way to add a column with cumulative values? For example,

I have a table:

id | product | price
1 | camera | 200
2 | watch | 100
3 | pencil | 20
4 | wallet | 10

I want to add an extra column and make the table like this:

id | product | price | cumulative price |
1 | camera | 200 | 200 |
2 | watch | 100 | 300 |
3 | pencil | 20 | 320 |
4 | wallet | 10 | 330 |

This question has an accepted answers - jump to answer

Answers

This discussion has been closed.