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 flat)
Thread:
Lists: pgsql-novice
hi!

i can access the first 100 records by this command:

=> select * from foo_table limit 100;
OR
=> 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?

thanks!

mel


In response to

Responses

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-2014 The PostgreSQL Global Development Group