Technical interview guide
Window Functions
Per-row calculations across a related set of rows (running totals, rankings, and row-over-row comparisons) without collapsing rows like GROUP BY does.
- Read
- 23 min
- Practice MCQs
- 25
- Interview Q&A
- 25
- Edition
- v3
- Editorial status
- Reviewed
Scope: SQL principles with PostgreSQL 18 examples; vendor-specific behavior must be verified.
Curated: · Written: · Reviewed: