[Solved] Find the mistake in this query:SELECT name, DENSE_RANK() OVER ORDER BY score DESC FROM players; — Ans: Missing parentheses after OVER | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Find the mistake in this query:

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

ADENSE_RANK() cannot be used with ORDER BY

BMissing PARTITION BY clause

CORDER BY should be outside the query

DMissing parentheses after OVER

Step-by-Step Solution

Solution:

Step 1: Check syntax of window functions
OVER must be followed by parentheses enclosing ORDER BY clause.
Step 2: Identify syntax error
Query misses parentheses after OVER, causing syntax error.
Final Answer:
Missing parentheses after OVER -> Option D
Quick Check:
OVER() requires parentheses even if empty [OK]

Quick Trick: Always use parentheses after OVER() [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the mistake in this query: