[Solved] Identify the error in this SQL query:SELECT employee_id, department, SUM(salary) OVER PARTITION BY department FROM employees; | SQL

SQL - Window Functions Fundamentals

Identify the error in this SQL query:

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

Adepartment column cannot be used in PARTITION BY.

BSUM() cannot be used with OVER clause.

CMissing parentheses around PARTITION BY clause inside OVER.

Demployee_id must be included in PARTITION BY.

Step-by-Step Solution

Solution:

Step 1: Check OVER clause syntax
The OVER clause must have parentheses enclosing PARTITION BY and other clauses.
Step 2: Identify missing parentheses
The query misses parentheses after OVER, it should be OVER (PARTITION BY department).
Final Answer:
Missing parentheses around PARTITION BY clause inside OVER. -> Option C
Quick Check:
OVER requires parentheses around PARTITION BY [OK]

Quick Trick: Always put parentheses after OVER, even if only PARTITION BY used [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL query: