Essential Books

Getting a running total

suggest change

Given this data:

date| amount | —— | —— | 2016-03-12 | 200 | 2016-03-11 | -50 | 2016-03-14 | 100 | 2016-03-15 | 100 | 2016-03-10 | -250 | 

SELECT date, amount, SUM(amount) OVER (ORDER BY date ASC) AS running
FROM operations
ORDER BY date ASC

will give you

date| amount | running —— | —— | —–– | 2016-03-10 | -250 | -250 | 2016-03-11 | -50 | -300 | 2016-03-12 | 200 | -100 | 2016-03-14 | 100 | 0 | 2016-03-15 | 100 | -100 |

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Window Fnctions:
*Setting up a flag if other rows have a common property
*Getting a running total
*Finding out-of-sequence records using the LAG function
*Adding the total rows selected to every row
*Getting the N most recent rows over multiple grouping
Table Of Contents