Limiting size of SQL Result Set

Posted in 1999

Topics: SQL Development & Query Writing, Platform-Specific Issues

Richard Auslander — Thu, 17 Jun 1999 16:48:28 -0700 — source: Informix-list mailing list archive (1991-1998)

We are using Dynamic Server, Version 7.30UC5, on Solaris. This version is new to me; I was told it has a new feature which enables one to specify the maximum number of rows to be returned by a SQL query, but I can't find it in our documentation. Can anyone help point me in the right direction? Many thanks! -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

↪ replying to Richard Auslander

Richard Lewis — Fri, 18 Jun 1999 10:11:30 +1000 — source: Informix-list mailing list archive (1991-1998)

Hi Richard, Try SELECT FIRST n * FROM table Richard Lewis Sydney, Australia Richard Auslander <rich@airflash.com> wrote in message news:3769894B.35913D92@airflash.com... > We are using Dynamic Server, Version 7.30UC5, on Solaris. This version > is new to me; I was told it has a new feature which enables one to > specify the maximum number of rows to be returned by a SQL query, but I > can't find it in our documentation. Can anyone help point me in the > right direction? Many thanks! > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > >