[Solved] Identify the syntax error in this query:SELECT id, ROW_NUMBER() PARTITION BY category ORDER BY price FROM products; | SQL

SQL - Window Functions Fundamentals

Identify the syntax error in this query:

SELECT id, ROW_NUMBER() PARTITION BY category ORDER BY price FROM products;

AIncorrect use of SELECT keyword

BMissing OVER() clause around PARTITION BY and ORDER BY

CORDER BY cannot be used with ROW_NUMBER()

DPARTITION BY should come after FROM clause

Step-by-Step Solution

Solution:

Step 1: Check ROW_NUMBER() syntax
The ROW_NUMBER() function requires an OVER() clause enclosing PARTITION BY and ORDER BY.
Step 2: Identify error
The query misses the OVER() keyword, causing a syntax error.
Final Answer:
Missing OVER() clause around PARTITION BY and ORDER BY -> Option B
Quick Check:
ROW_NUMBER() must have OVER() [OK]

Quick Trick: ROW_NUMBER() always needs OVER() clause [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 query: