RE: How to select first 50 rows?

Posted in 2003

miyaki — Wed, 29 Oct 2003 00:49:12 -0800 (PST) — source: Usenet: comp.databases.informix

The FIRST function will only selecting the first 50 rows. What if i want to select the next 50 rows? Actually what i'm looking at is a sql that able to return me every 50 rows of records at one time. Thanks for the helps. Miyaki --- Dirk Moolman <DirkM@mxgroup.co.za> wrote: > > select first 50 * > from <your_table>> > > > -----Original Message----- > From: miyaki [mailto:lcib@yahoo.com] > Sent: Wednesday, October 29, 2003 3:52 AM > To: ids@iiug.org; informix-list@iiug.org > Subject: How to select first 50 rows? > > Hi guys, > > If i have a total 500 rows of records set, but i > need > to return 50 rows at one time by a sql statement. Do > you know how to do that? > > Thanks in advance. > > Miyaki > > __________________________________ > Do you Yahoo!? > Exclusive Video Premiere - Britney Spears > http://launch.yahoo.com/promos/britneyspears/ > sending to informix-list __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ sending to informix-list