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

SQL - Window Functions Fundamentals

Identify the error in this query:

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

ASUM() cannot be used as a window function.

BCannot use window function with GROUP BY without including all selected columns in GROUP BY.

CMissing ORDER BY clause in window function.

DNo error; query is valid.

Step-by-Step Solution

Solution:

Step 1: Analyze GROUP BY and window function interaction
When GROUP BY is used, all selected columns except aggregates must be in GROUP BY.
Step 2: Identify missing columns in GROUP BY
salary is selected but not in GROUP BY, causing error.
Final Answer:
Cannot use window function with GROUP BY without including all selected columns in GROUP BY. -> Option B
Quick Check:
GROUP BY columns must match SELECT non-aggregates = B [OK]

Quick Trick: All non-aggregated columns must be in GROUP BY [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 query: