SQL - Advanced Window Functions
Which of the following is the correct syntax to use the
LEAD function to get the next row's salary ordered by employee_id?Which of the following is the correct syntax to use the LEAD function to get the next row's salary ordered by employee_id?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall LEAD function syntax
The LEAD function requires an OVER clause with an ORDER BY to define the row order for accessing the next row.Step 2: Match syntax with options
LEAD(salary) OVER (ORDER BY employee_id) correctly uses LEAD(salary) OVER (ORDER BY employee_id). Options A, B, and D have incorrect syntax.Final Answer:
LEAD(salary) OVER (ORDER BY employee_id) -> Option AQuick Check:
LEAD + OVER + ORDER BY = correct syntax [OK]
Quick Trick: LEAD needs OVER(ORDER BY ...) syntax [OK]
Common Mistakes:
- Omitting OVER clause
- Placing ORDER BY inside LEAD parentheses
- Using BY instead of ORDER BY
Master "Advanced Window Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes