[Solved] Find the issue in this query to get top 3 sales per region:SELECT region, salesperson, amount FROM sales WHERE ROW_NUMBER() OVER (PARTITION BY region ORDER BY amount DESC) | SQL

SQL - Advanced Query Patterns

Find the issue in this query to get top 3 sales per region:

SELECT region, salesperson, amount FROM sales WHERE ROW_NUMBER() OVER (PARTITION BY region ORDER BY amount DESC) <= 3;

AMissing GROUP BY clause

BROW_NUMBER() cannot be used in WHERE clause directly

CORDER BY cannot be inside ROW_NUMBER()

DPARTITION BY is invalid in this context

Step-by-Step Solution

Solution:

Step 1: Understand function usage in WHERE clause
Window functions like ROW_NUMBER() cannot be used directly in WHERE clause.
Step 2: Correct usage
Use a subquery or CTE to assign row numbers, then filter in outer query.
Final Answer:
ROW_NUMBER() cannot be used in WHERE clause directly -> Option B
Quick Check:
Window functions need subquery for filtering [OK]

Quick Trick: Use subquery to filter on ROW_NUMBER() results [OK]

Common Mistakes:

Using window functions directly in WHERE
Confusing PARTITION BY with GROUP BY
Ignoring need for subquery or CTE

Master "Advanced Query Patterns" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Find the issue in this query to get top 3 sales per region:

Step 1: Understand function usage in WHERE clause

Step 2: Correct usage

Final Answer:

Quick Check:

Want More Practice?