Oninit cdi / Archive
Talk to an expert →

Want to get the first n records

Posted in 2000

Topics: Versions, Editions & End-of-Life

vtnguyen — — source: Informix-list mailing list archive (1991-1998)

Hi there, I would like to get only the first 100 records from the result set of the query. How do I do that? (I am using IDS 7.23.). Thanks Tung Nguyen

↪ replying to vtnguyen
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

vtnguyen wrote: > I would like to get only the first 100 records from the result set of > the query. > How do I do that? (I am using IDS 7.23.). Probably by upgrading (to 7.31 or 9.2x). SELECT FIRST 100 * FROM SomeWhere will work in some versions; I don't immediately recall whether 7.2x is one of those versions. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>

↪ replying to Jonathan Leffler
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <390E6C91.57DF9BA0@earthlink.net>, Jonathan Leffler <jleffler@earthlink.net> wrote: > vtnguyen wrote: > > > I would like to get only the first 100 records from the result set of > > the query. > > How do I do that? (I am using IDS 7.23.). > > Probably by upgrading (to 7.31 or 9.2x). > > SELECT FIRST 100 * FROM SomeWhere> > will work in some versions; I don't immediately recall > whether 7.2x is one of those versions. > It isn't. > -- > Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN > #include <disclaimer.h> > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary