Re: displaying records from X to Y - Mailing list pgsql-novice

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