Mel,
> => select * from foo_table limit 100;> OR> => select * from foo_table order by foo_column desc limit 100;
Easy:
SELECT * FROM foo_table LIMIT 100 OFFSET 100;
-Josh Berkus