>_
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.
presets
running total
top-n per group
month-over-month
moving average
rank vs dense_rank
sales — 12 rows, computed live
takeaway
sql
prompt for claude
copy