Re: First N records in SELECT

Posted in 1997

Kerry Sainsbury — Thu, 31 Jul 1997 21:00:10 +1300 — source: Informix-list mailing list archive (1991-1998)

In article <5ra696$m7t@castle.topaz.kiev.ua>, parker@topaz.kiev.ua (Slavik Anosov) wrote: >Does anybody know something in Informix ODS 7.1 that perform functions of >Oracle's ROWNUM pseudo-column? I need to retrieve only first N records in >select. This doesn't really help, but wait until 7.3 :-) ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.10 May 1997 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/