midSQL
What are window functions?
Updated May 17, 2026
Short answer
Window functions perform calculations across rows.
Deep explanation
They allow ranking, running totals without collapsing rows.
Real-world example
Ranking employees by salary.
Common mistakes
- Confusing with GROUP BY aggregation.
Follow-up questions
- What is OVER clause?
- Difference from aggregation?