SQL · Functions and expressions

sum() over()

A running total without collapsing rows, unlike GROUP BY.

sqlRunnable example sql course

Syntax

sum(x) over (order by …)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30))
SELECT minutes, sum(minutes) OVER (ORDER BY minutes) AS running FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.