Why Running totals with SUM OVER in SQL? - Purpose & Use Cases

The Big Idea

Discover how a simple SQL trick saves hours of tedious adding and keeps your data error-free!

The Scenario

Imagine you have a list of daily sales in a spreadsheet, and you want to know the total sales up to each day. Doing this by hand means adding each day's sales to all previous days manually.

The Problem

Manually adding numbers for each day is slow and easy to mess up. If you have hundreds of days, it becomes a big headache and mistakes can sneak in unnoticed.

The Solution

Using SUM() OVER() in SQL automatically calculates running totals for you. It adds each row's value to the sum of all previous rows in the order you specify, instantly and accurately.

Before vs After

✗ Before

SELECT date, sales FROM daily_sales;
-- Then add sales manually in a spreadsheet

✓ After

SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS running_total FROM daily_sales;

What It Enables

This lets you quickly see cumulative totals, track progress over time, and analyze trends without extra manual work.

Real Life Example

A store manager can instantly see how total sales grow day by day during a promotion, helping decide if the campaign is working.

Key Takeaways

Manual running totals are slow and error-prone.

SUM() OVER() automates cumulative calculations.

It helps track progress and trends easily in data.