SQL Window Functions Don't Have to Be Scary 🪟

Introduction If you've ever seen OVER (PARTITION BY ... ORDER BY ...) in a SQL query and quietly closed the tab — this post is for you. Window functions are one of those topics that look intimidating at first but become incredibly powerful once they click. And once you learn them, you'll wonder how you ever wrote SQL without them. By the end of this post you'll understand 5 essential window functions, when to use each one, and exactly how they differ from each other. Let's go. What Even Is a Window Function? A regular aggregate function like SUM() or COUNT() collapses your rows into a single result. Window functions do calculations across rows — without collapsing them. -- Regular aggregate: collapses all rows into one SELECT dept , SUM ( salary ) FROM employees GROUP BY dept ; -- Window function: keeps all rows, adds a calculated column SELECT name , dept , salary , SUM ( salary ) OVER ( PARTITION BY dept ) AS dept_total FROM employees ; The key difference: GROUP BY gives you one row