[Solved] What will this query return?SELECT id, amount, ROW_NUMBER() OVER (PARTITION BY region ORDER BY amount DESC) AS rank FROM sales; | SQL

SQL - Window Functions Fundamentals

What will this query return?
SELECT id, amount, ROW_NUMBER() OVER (PARTITION BY region ORDER BY amount DESC) AS rank FROM sales;

ARandom row numbers without order

BTotal count of rows per region

CSum of amounts per region

DA rank of rows within each region ordered by amount descending

Step-by-Step Solution

Solution:

Step 1: Understand ROW_NUMBER() OVER with PARTITION and ORDER BY
ROW_NUMBER() assigns a unique rank number to each row within each region ordered by amount descending.
Step 2: Interpret the rank column
Rows with highest amount in each region get rank 1, next rank 2, and so on.
Final Answer:
A rank of rows within each region ordered by amount descending -> Option D
Quick Check:
ROW_NUMBER() ranks rows per partition [OK]

Quick Trick: ROW_NUMBER() ranks rows within partitions [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will this query return?