[Solved] Identify the error in this query:SELECT employee_id, department, RANK() OVER PARTITION BY department ORDER BY salary DESC FROM employees; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Identify the error in this query:

SELECT employee_id, department, RANK() OVER PARTITION BY department ORDER BY salary DESC FROM employees;

AMissing parentheses around PARTITION BY and ORDER BY clauses.

BRANK() cannot be used with PARTITION BY.

CORDER BY cannot be used inside window functions.

Demployee_id must be included in PARTITION BY.

Step-by-Step Solution

Solution:

Step 1: Check window function syntax
Window functions require OVER() with parentheses enclosing PARTITION BY and ORDER BY.
Step 2: Identify missing parentheses
The query misses parentheses after OVER, causing syntax error.
Final Answer:
Missing parentheses around PARTITION BY and ORDER BY clauses. -> Option A
Quick Check:
OVER() must enclose PARTITION BY and ORDER BY [OK]

Quick Trick: Always use parentheses after OVER() for window clauses [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: