SQL - Window Functions Fundamentals
Identify the error in this query:
SELECT id, amount, SUM(amount) PARTITION BY region FROM sales;
SELECT id, amount, SUM(amount) PARTITION BY region FROM sales;
Identify the error in this query:
medium📝 Debug Q6 of 15
Step-by-Step Solution
Solution:
Step 1: Check window function syntax
Window functions require OVER() clause to specify partitioning or ordering.Step 2: Identify missing OVER()
The query uses PARTITION BY without OVER(), which causes syntax error.Final Answer:
Missing OVER() clause after SUM(amount) -> Option DQuick Check:
Window functions need OVER() [OK]
Quick Trick: Always use OVER() with window functions [OK]
Common Mistakes:
- Omitting OVER() clause
- Confusing PARTITION BY with GROUP BY
- Thinking SUM() can't be in SELECT
Master "Window Functions Fundamentals" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes