Loading…
A running total adds up values progressively:
SUM(amount) OVER(ORDER BY date)
The ORDER BY determines the accumulation order.
Example:
| date | amount | running_total |
|---|---|---|
| Jan 1 | 100 | 100 |
| Jan 2 | 50 | 150 |
| Jan 3 | 75 | 225 |
Show payments with a running total:
Downloading SQL engine… (one-time)
This runs entirely in your browser and is cached for next time.