MySQL, PostgreSQL, SQLite

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

/* from the 6th to the 10th rows */
SELECT Name
FROM country
LIMIT 5, 5