Q1. How can we get row x to row y in a resultset using SQL Standard?
A. It is not possible, we have to iterate through resultset and get it
B. SELECT... FROM ... WHERE ... ORDER BY ... OFFSET x ROWS FETCH FIRST y ROWS ONLY
C. SELECT ...BETWEEN (x, y) FROM ... WHERE ... ORDER BY ...
D. SELECT... FROM ... WHERE ... and ROW_NUM > x and ROW_NUM < y ORDER BY ...