From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
---|---|
To: | "'mel(at)gmanmi(dot)tv'" <mel(at)gmanmi(dot)tv>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: displaying records from X to Y |
Date: | 2002-10-16 07:06:30 |
Message-ID: | 034A824BAA3FBA4CA0CBEF1031A02F350E3FF5@zablv02001.vodacom.corp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
U could try
select * from foo_table limit 100 offset 100;
-----Original Message-----
From: Mel Jamero [mailto:mel(at)gmanmi(dot)tv]
Sent: Wednesday, October 16, 2002 4:25 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] displaying records from X to Y
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-10-16 07:14:45 | Re: displaying records from X to Y |
Previous Message | Nelson Yong | 2002-10-16 06:55:48 | how to create secondary key!! |