[Solved] Identify the error in this query:SELECT id, amount, SUM(amount) OVER ORDER BY date AS running_total FROM sales; | SQL

SQL - Advanced Window Functions

Identify the error in this query:

SELECT id, amount, SUM(amount) OVER ORDER BY date AS running_total FROM sales;

AMissing GROUP BY clause

BMissing parentheses after OVER

CSUM() cannot be used with OVER

DORDER BY cannot be used inside OVER

Step-by-Step Solution

Solution:

Step 1: Check syntax of window function
OVER clause must have parentheses even if empty or with ORDER BY inside.
Step 2: Identify missing parentheses
Query has OVER ORDER BY without parentheses, which is invalid syntax.
Final Answer:
Missing parentheses after OVER -> Option B
Quick Check:
OVER() requires parentheses [OK]

Quick Trick: Always use parentheses after OVER, even with ORDER BY [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this query: