selection limit

In this moment I can make a selection of the first (or last) 10 records from
a table.
select * from table_name limit 10;
I want to make a selection of the next 10 records (from 10 to 20 or from 50
to 60) from a table.

How can I do that?



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend