SQL - Window Functions Fundamentals
Which of the following is the correct syntax to specify a window frame from 2 rows before to current row using
ROWS BETWEEN?Which of the following is the correct syntax to specify a window frame from 2 rows before to current row using ROWS BETWEEN?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Understand frame boundaries order
The syntax isROWS BETWEEN X AND Ywhere X is the start and Y is the end of the frame.Step 2: Identify correct order for 2 rows before to current
Since 2 rows before is the start and current row is the end, it must beROWS BETWEEN 2 PRECEDING AND CURRENT ROW.Final Answer:
ROWS BETWEEN 2 PRECEDING AND CURRENT ROW -> Option AQuick Check:
Start to end order matters = A [OK]
Quick Trick: Start boundary comes first, then end boundary in ROWS BETWEEN [OK]
Common Mistakes:
- Reversing the order of boundaries
- Using FOLLOWING instead of PRECEDING incorrectly
- Omitting CURRENT ROW keyword
Master "Window Functions Fundamentals" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes