Consider the example given below:
What is the range of rows that will be selected if you write the following frame clause? (Assume that the current row is Row 6)
ORDER BY X ROWS
BETWEEN 2 PRECEDING AND 3 FOLLOWING
Explanation: '2 PRECEDING' means the frame clause will select Row 5 and Row 4. '3 FOLLOWING' means that Rows 7, 8 and 9 will also be selected. It goes without saying that the current row, Row 6, is included in the frame.