Re: displaying records from X to Y

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: <mel(at)gmanmi(dot)tv>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: displaying records from X to Y
Date: 2002-10-16 04:10:40
Message-ID: web-1788146@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nelson Yong 2002-10-16 06:55:48 how to create secondary key!!
Previous Message Mel Jamero 2002-10-16 02:25:29 displaying records from X to Y