Average within partition

sql

SELECT employee_id, department_id, salary,
       AVG(salary) OVER (PARTITION BY department_id) AS dept_avg_salary
FROM employees;

Explanation

Window functions differ from GROUP BY because they keep row-level detail.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Window Function Basics

Number rows within an ordered partition.

Open In sheetsqlsame section

Assign ordered rankings with or without gaps.

Open In sheetsqlsame section

Accumulate values across an ordered window.

Open In sheetsqlsame section

Read a value from the previous row in the same partition.

Open In sheetsql1 tag match

Divide ordered rows into a fixed number of groups.

Open In sheetsql1 tag match

Read a value from the next row in the same partition.

Open In sheetsql1 tag match