MySQL MCQ

Displaying 1 - 10 of 30

MySQL: Defining Frames (Preceding and following)

 Consider the example given below:

mysql frames preceding and following

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.