Skip site navigation (1) Skip section navigation (2)

displaying records from X to Y

From: "Mel Jamero" <mel(at)gmanmi(dot)tv>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: displaying records from X to Y
Date: 2002-10-16 02:25:29
Message-ID: 000401c274bb$4bce41b0$1b06a8c0@mel (view raw or whole thread)
Lists: pgsql-novice

i can access the first 100 records by this command:

=> select * from foo_table limit 100;
=> select * from foo_table order by foo_column desc limit 100;

how do i access the next 100 records without having the first 100 displayed?



In response to


pgsql-novice by date

Next:From: Josh BerkusDate: 2002-10-16 04:10:40
Subject: Re: displaying records from X to Y
Previous:From: János LöbbDate: 2002-10-15 22:33:09
Subject: jdbc connection from Eomodeler to postgresql 7.2.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group