[Solved] What is the syntax error in the following SQL query?SELECT Department, Employee, AVG(Salary) OVER PARTITION BY Department FROM Employees; | SQL

SQL - Window Functions Fundamentals

What is the syntax error in the following SQL query?

SELECT Department, Employee, AVG(Salary) OVER PARTITION BY Department FROM Employees;

AIncorrect use of AVG function without GROUP BY.

BMissing parentheses around the OVER clause.

CPARTITION BY cannot be used with aggregate functions.

DOVER clause must follow the GROUP BY clause.

Step-by-Step Solution

Solution:

Step 1: Check OVER clause syntax
The OVER clause must be enclosed in parentheses when used with PARTITION BY.
Step 2: Identify the error
The query misses parentheses around PARTITION BY Department, causing a syntax error.
Final Answer:
Missing parentheses around the OVER clause. -> Option B
Quick Check:
Always use parentheses after OVER with PARTITION BY. [OK]

Quick Trick: Use parentheses after OVER with PARTITION BY [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is the syntax error in the following SQL query?