SQL Window Functions - Basics

1. OVER() Applies a function over all rows if not partitioned. SELECT name, salary, AVG(salary) OVER() AS avg_salary FROM employees; Calculates the overall average salary for every row. 2. PARTITION BY Divides result into groups (like GRO...