SQL - Window Functions Fundamentals
Which of the following is a valid frame specification using
ROWS BETWEEN?Which of the following is a valid frame specification using ROWS BETWEEN?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Review valid ROWS BETWEEN syntax
The syntax must specify a start and end point relative to the current row, using PRECEDING or FOLLOWING or CURRENT ROW.Step 2: Check each option
ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING uses valid syntax: from current row to 3 following rows. ROWS BETWEEN 3 PREVIOUS AND CURRENT ROW uses 'PREVIOUS' which is invalid; correct term is PRECEDING. ROWS BETWEEN 3 AND 1 PRECEDING has reversed order and invalid syntax. ROWS BETWEEN 1 FOLLOWING AND 3 PRECEDING reverses frame order, which is invalid.Final Answer:
ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING -> Option CQuick Check:
Valid syntax = ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING [OK]
Quick Trick: Use PRECEDING/FOLLOWING, not PREVIOUS, in ROWS BETWEEN [OK]
Common Mistakes:
- Using 'PREVIOUS' instead of 'PRECEDING'
- Reversing frame start and end
- 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