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

PostgreSQL - Window Functions in PostgreSQL

Find the error in this query:

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

AThe OVER() clause cannot be used without a GROUP BY clause.

BRANK() cannot be used with ORDER BY in window functions.

CThe PARTITION BY clause must come before ORDER BY inside the OVER() clause.

DThe query is missing a WHERE clause to filter departments.

Step-by-Step Solution

Solution:

Step 1: Check OVER() clause syntax
PARTITION BY must appear before ORDER BY inside the OVER() parentheses.
Step 2: Identify error
The query places ORDER BY before PARTITION BY, which is invalid syntax.
Final Answer:
The PARTITION BY clause must come before ORDER BY inside the OVER() clause. -> Option C
Quick Check:
PARTITION BY precedes ORDER BY in OVER() [OK]

Quick Trick: PARTITION BY must precede ORDER BY inside OVER() [OK]

Common Mistakes:

Master "Window Functions in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this query: