What does the RANK() OVER (PARTITION BY category ORDER BY price DESC) window function do in PostgreSQL?

easy📝 Conceptual Q1 of 15

PostgreSQL - Window Functions in PostgreSQL

What does the RANK() OVER (PARTITION BY category ORDER BY price DESC) window function do in PostgreSQL?

AAssigns a rank to each row within each category, with ties receiving the same rank

BCounts the number of rows in each category

CCalculates the cumulative sum of prices within each category

DReturns the total number of categories in the table

Step-by-Step Solution

Solution:

Step 1: Understand RANK() function behavior
The RANK() function assigns ranks to rows ordered by a specified column, giving the same rank to ties.
Step 2: Analyze PARTITION BY usage
Partitioning by category means ranking restarts for each category group separately.
Final Answer:
Assigns a rank to each row within each category, with ties receiving the same rank -> Option A
Quick Check:
RANK() with PARTITION BY = Assign ranks with ties [OK]

Quick Trick: RANK() gives same rank to ties within partitions [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free