Retrieving 5 rows works as expected: SELECT * FROM table LIMIT 5
But, attempting to get 5 more rows gets no results: SELECT * FROM table LIMIT 5 OFFSET 5
To get rows 6-10 you need to increase the limit to 10: SELECT * FROM table LIMIT 10 OFFSET 5
Instead of retrieving from OFFSET + 1 to OFFSET + LIMIT it retrieves from OFFSET + 1toLIMIT`.