It's probably something like this though:

select username, firstname, surname
from users
limit 10
offset 20;
[download]

This will give you numbers 21-30.

Yeah, except that if you change offset to 150, you might get the same results. In a different order. You do need to order your results to have some chance of a meaningful result. And just pray that between invocations, noone deleted or added records.

Abigail