Re: Need help paging through record sets

From: knut(dot)suebert(at)web(dot)de
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Need help paging through record sets
Date: 2002-12-21 18:32:37
Message-ID: 20021221183237.GD964@fraxinus.reticulum
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Steve Crawford schrieb:

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

> On Friday 20 December 2002 12:53 pm, cmccormick(at)mailsnare(dot)net wrote:

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

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Yapt 2002-12-21 19:12:50 Parameterized Views on 7.3
Previous Message Peter Galbavy 2002-12-21 11:57:58 Re: Need help paging through record sets