← Quiz: Window Frames: all 10 questions
Quiz: Window Frames · Question 1 of 10
What does the frame ROWS BETWEEN 2 PRECEDING AND CURRENT ROW include?
What does the frame ROWS BETWEEN 2 PRECEDING AND CURRENT ROW include?
- A.The current row and the 2 rows after it
- B.The current row and the 2 rows before it
- C.Only the 2 rows before the current row
- D.Every row in the partition
Answer & explanation
Correct answer: The current row and the 2 rows before it
2 PRECEDING plus CURRENT ROW is three rows ending at the current one.
Can you get the rest right without peeking?
Take the timed Quiz: Window Frames quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →