Re: displaying records from X to Y

U could try

select * from foo_table limit 100 offset 100;

-----Original Message-----
From: Mel Jamero [mailto:mel@gmanmi.tv]
Sent: Wednesday, October 16, 2002 4:25 AM
To: pgsql-novice@postgresql.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@postgresql.org so that your
message can get through to the mailing list cleanly