BrushBefore Quick revision. Clear recall. Better interviews.
Back to search

What are window functions?

Window functions compute values across a related set of rows without collapsing them into one row per group.

SQL Medium Theory

What are window functions?

Window functions compute values across a related set of rows without collapsing them into one row per group.

  • Use OVER clause
  • Great for ranking and running totals
  • Keeps detail rows
#analytics #sql #window-functions

What are window functions?