Re: Need help paging through record sets - Mailing list pgsql-sql

Steve Crawford schrieb:

> select * from foo order by date limit 100 offset 100;

> On Friday 20 December 2002 12:53 pm, cmccormick@mailsnare.net wrote:

> > 1.  SORT records by the date field, descending

select * from foo order by date desc limit 100 offset 100;                               ^^^^