/* first five rows */
SELECT Name
FROM country
ROWS 5

/* from the 6th to the 10th rows */
SELECT Name
FROM country
ROWS 6 TO 10