[Solved] What will be the output of this query?SELECT name, score, DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank FROM players;Given scores: 50, 40, 40, 30. | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

What will be the output of this query?

SELECT name, score, DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank FROM players;

Given scores: 50, 40, 40, 30.

ADense ranks: 1, 2, 3, 4

BDense ranks: 1, 2, 2, 3

CDense ranks: 1, 1, 2, 3

DDense ranks: 1, 1, 1, 2

Step-by-Step Solution

Solution:

Step 1: Understand DENSE_RANK() behavior
DENSE_RANK() assigns same rank to ties without gaps.
Step 2: Assign dense ranks to scores
Score 50 gets 1, scores 40 get 2, score 30 gets 3.
Final Answer:
Dense ranks: 1, 2, 2, 3 -> Option B
Quick Check:
DENSE_RANK() no gaps in ranks = Dense ranks: 1, 2, 2, 3 [OK]

Quick Trick: DENSE_RANK() assigns consecutive ranks even with ties [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What will be the output of this query?