[Solved] Identify the syntax error in this SQL query using a window function:SELECT id, amount, RANK() OVER PARTITION BY category ORDER BY amount DESC FROM products; | SQL

SQL - Window Functions Fundamentals

Identify the syntax error in this SQL query using a window function:

SELECT id, amount, RANK() OVER PARTITION BY category ORDER BY amount DESC FROM products;

AMissing parentheses around PARTITION BY and ORDER BY clauses inside OVER()

BRANK() cannot be used with ORDER BY

CPARTITION BY cannot be used without GROUP BY

DORDER BY cannot be used inside OVER()

Step-by-Step Solution

Solution:

Step 1: Review window function syntax
The OVER clause must enclose partitioning and ordering clauses inside parentheses.
Step 2: Analyze the query
The query lacks parentheses after OVER keyword: it should be OVER (PARTITION BY category ORDER BY amount DESC).
Step 3: Evaluate options
Missing parentheses around PARTITION BY and ORDER BY clauses inside OVER() correctly identifies missing parentheses.
Options B, C, and D are incorrect statements about window functions.
Final Answer:
Option A -> Option A
Quick Check:
OVER() must enclose PARTITION BY and ORDER BY [OK]

Quick Trick: Always use parentheses after OVER keyword [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the syntax error in this SQL query using a window function: