[Solved] Identify the error in this query:SELECT employee_id, salary, LEAD(salary) ORDER BY employee_id FROM employees; | PostgreSQL

PostgreSQL - Window Functions in PostgreSQL

Identify the error in this query:

SELECT employee_id, salary, LEAD(salary) ORDER BY employee_id FROM employees;

AORDER BY should be inside LEAD() function

BMissing OVER() clause for LEAD function

CLEAD cannot be used with salary column

Demployee_id must be in GROUP BY clause

Step-by-Step Solution

Solution:

Step 1: Check LEAD function syntax
LEAD requires an OVER() clause to specify ordering and partitioning.
Step 2: Analyze query structure
The query uses LEAD(salary) without OVER(), causing a syntax error.
Final Answer:
Missing OVER() clause for LEAD function -> Option B
Quick Check:
Window functions need OVER() [OK]

Quick Trick: Always use OVER() with LEAD/LAG [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: