[Solved] Identify the error in this SQL query:SELECT employee_id, NTH_VALUE(salary, 1) OVER (PARTITION BY department_id) FROM employees; | SQL

SQL - Advanced Window Functions

Identify the error in this SQL query:

SELECT employee_id, NTH_VALUE(salary, 1) OVER (PARTITION BY department_id) FROM employees;

AMissing ORDER BY clause inside OVER() causes error.

BNTH_VALUE cannot be used with PARTITION BY.

CThe function parameters are in wrong order.

DNo error; query is correct.

Step-by-Step Solution

Solution:

Step 1: Check the OVER() clause requirements
NTH_VALUE requires an ORDER BY clause inside OVER() to define the row order for nth value selection.
Step 2: Identify missing ORDER BY
The query uses PARTITION BY but lacks ORDER BY, which causes a syntax error.
Final Answer:
Missing ORDER BY clause inside OVER() causes error. -> Option A
Quick Check:
NTH_VALUE needs ORDER BY in OVER() [OK]

Quick Trick: Always include ORDER BY inside OVER() with NTH_VALUE [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL query: