window functions

1 article · newest first

Flat illustration of a person holding a coral frame over three highlighted rows in a tall stack of table rows

SQL window functions explained: running totals, rank and LAG in Postgres

GROUP BY collapses your rows and you lose the detail. A window function keeps every row and adds the total, the rank or the previous value beside it. Eight runnable PostgreSQL examples, including the tie trap that makes running totals jump.

Aliteq Team · 14h ago · 11 min