[Solved] What is wrong with this query?SELECT employee_id, salary, SUM(salary) OVER PARTITION BY department ORDER BY employee_id FROM employees; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

What is wrong with this query?

SELECT employee_id, salary, SUM(salary) OVER PARTITION BY department ORDER BY employee_id FROM employees;

AIncorrect use of ORDER BY outside OVER clause

BMissing parentheses around the OVER clause

CSUM() cannot be used with window functions

Demployee_id cannot be selected with window functions

Step-by-Step Solution

Solution:

Step 1: Check OVER clause syntax
The OVER clause must be enclosed in parentheses.
Step 2: Identify missing parentheses
Query uses OVER PARTITION BY without parentheses, which is invalid.
Final Answer:
Missing parentheses around the OVER clause -> Option B
Quick Check:
OVER clause requires parentheses [OK]

Quick Trick: Always use parentheses after OVER [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with this query?