displaying records from X to Y

hi!

i can access the first 100 records by this command:

=> select * from foo_table limit 100;
OR
=> select * from foo_table order by foo_column desc limit 100;

how do i access the next 100 records without having the first 100 displayed?

thanks!

mel