[Solved] What is wrong with this SQL query?SELECT employee_id, NTH_VALUE(salary, -1) OVER (ORDER BY salary) AS nth_salary FROM Employees; | SQL

SQL - Advanced Window Functions

What is wrong with this SQL query?

SELECT employee_id, NTH_VALUE(salary, -1) OVER (ORDER BY salary) AS nth_salary FROM Employees;

AThe position argument for NTH_VALUE cannot be negative.

BThe ORDER BY clause is missing a PARTITION BY clause.

CNTH_VALUE requires a GROUP BY clause to work properly.

DThe query should use FIRST_VALUE instead of NTH_VALUE.

Step-by-Step Solution

Solution:

Step 1: Check the NTH_VALUE syntax
The second argument (position) must be a positive integer indicating which row's value to return.
Step 2: Analyze the query
Using -1 as the position is invalid and causes an error.
Final Answer:
The position argument for NTH_VALUE cannot be negative. -> Option A
Quick Check:
Position must be positive integer [OK]

Quick Trick: NTH_VALUE position must be positive integer [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with this SQL query?