[Solved] What is wrong with the following query?SELECT employee_id, RANK() score OVER (ORDER BY score DESC) FROM employees; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

What is wrong with the following query?

SELECT employee_id, RANK() score OVER (ORDER BY score DESC) FROM employees;

AThe alias 'score' is placed incorrectly between RANK() and OVER()

BRANK() cannot be used with ORDER BY clause

CMissing PARTITION BY clause inside OVER()

DRANK() requires a parameter inside the parentheses

Step-by-Step Solution

Solution:

Step 1: Analyze the syntax of RANK()
The correct syntax is RANK() OVER (ORDER BY column). The alias should come after the entire expression.
Step 2: Identify the error
In the query, 'score' is incorrectly placed between RANK() and OVER(), which is invalid.
Final Answer:
Option A -> Option A
Quick Check:
Alias must be after the window function expression [OK]

Quick Trick: Alias goes after window function, not inside parentheses [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is wrong with the following query?