How can I retrieve a record set segment by segment.

ex:- If I say "select * from some_table" and it returns 100 rows,

How can I only retrieve the rows from 20 to 30. I do not want to go from the
first row to the 20th one. Is it possible and what is the SQL syntax for
that......

Thanks in advance.....
kind regards

Chris