Solution:Step 1: Understand SUM() OVER with PARTITION BYSUM() with PARTITION BY calculates sum per group; here, per department.Step 2: Recognize repeated value per rowThe sum is repeated on every row within the department, not a running total or average.Final Answer:Total salary for each department

[Solved] Consider the query:SELECT department, employee, salary, SUM(salary) OVER (PARTITION BY department) AS dept_total FROM employees;What does the dept_total column show? | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Consider the query:

SELECT department, employee, salary, SUM(salary) OVER (PARTITION BY department) AS dept_total FROM employees;

What does the dept_total column show?

ATotal salary for each department repeated on every row of that department

BTotal salary for all employees in the table

CRunning total of salary ordered by employee name

DAverage salary per employee in each department

Step-by-Step Solution

Solution:

Step 1: Understand SUM() OVER with PARTITION BY
SUM() with PARTITION BY calculates sum per group; here, per department.
Step 2: Recognize repeated value per row
The sum is repeated on every row within the department, not a running total or average.
Final Answer:
Total salary for each department repeated on every row of that department -> Option A
Quick Check:
SUM() OVER PARTITION BY = group total repeated [OK]

Quick Trick: SUM() OVER PARTITION BY repeats group total on each row [OK]

Common Mistakes:

Thinking it sums entire table ignoring partition
Confusing with running total or average
Expecting different values per row in same partition

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Consider the query:

Step 1: Understand SUM() OVER with PARTITION BY

Step 2: Recognize repeated value per row

Final Answer:

Quick Check:

Want More Practice?