Fig. 1 · Interactive · Analytics / SQL

SQL window functions

The OVER clause, made visible. Pick a function, shape its window with PARTITION BY, ORDER BY and a frame, then hover any row to see exactly which rows feed its value. Or press play to walk the whole table.

Rows: 12
Functions: 8

Presets

A · Window specover (…)

Function

Partition by

Order by

Frame

B · sales — 12 rowscomputed live

C · Takeaway