[Solved] Identify the error in this query:SELECT name, DENSE_RANK(score) OVER (ORDER BY score DESC) FROM players; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Identify the error in this query:

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

ADENSE_RANK() should not have a column inside the parentheses.

BDENSE_RANK() cannot be used without PARTITION BY clause.

CORDER BY clause is missing in the OVER() clause.

DThe query is correct and will run without errors.

Step-by-Step Solution

Solution:

Step 1: Check DENSE_RANK() syntax
DENSE_RANK() does not take any arguments inside parentheses; it is called as DENSE_RANK() OVER (...).
Step 2: Identify the error in the query
The query incorrectly uses DENSE_RANK(score), which causes a syntax error.
Final Answer:
DENSE_RANK() should not have a column inside the parentheses. -> Option A
Quick Check:
DENSE_RANK() has empty parentheses [OK]

Quick Trick: Window functions have empty parentheses, column goes in ORDER BY [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: