By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PersonName | Amount | RunningTotal |
---|---|---|
Ben | 10 | 10 |
Bob | 325 | 335 |
Michael | 99 | 434 |
Susan | 7 | 441 |
col | PersonName | Amount | rn | RunningTotal |
---|---|---|---|---|
Ben|10, Bob|325, Susan|7, Michael|99 | Ben | 10 | 0 | 10 |
Ben|10, Bob|325, Susan|7, Michael|99 | Bob | 325 | 1 | 335 |
Ben|10, Bob|325, Susan|7, Michael|99 | Susan | 7 | 2 | 342 |
Ben|10, Bob|325, Susan|7, Michael|99 | Michael | 99 | 3 | 441 |