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

From knut.suebert@web.de
Subject Re: Need help paging through record sets
Date
Msg-id 20021221183237.GD964@fraxinus.reticulum
Whole thread Raw
In response to Re: Need help paging through record sets  (Steve Crawford <scrawford@pinpointresearch.com>)
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;                               ^^^^


pgsql-sql by date:

Previous
From: "Peter Galbavy"
Date:
Subject: Re: Need help paging through record sets
Next
From: Terry Yapt
Date:
Subject: Parameterized Views on 7.3