max rows

Posted in 1999

mission critical — Thu, 29 Jul 1999 11:36:44 -0700 — source: Informix-list mailing list archive (1991-1998)

Is there a way to limit the maximum number of returned rows in a SQL Select (akin to the mysql LIMIT command?) I'm on universal server 9.13/solaris. Thanks Philip yukonc@teleport.com

↪ replying to mission critical

Art S. Kagel — Thu, 29 Jul 1999 14:45:50 -0400 — source: Informix-list mailing list archive (1991-1998)

This is a 7.3x feature so it may not be in 9.13 and you will have to wait to upgrade to IDS2000 when it ships. SELECT FIRST 10 a, b, c FROM table_a .... Art S. Kagel mission critical wrote: > > Is there a way to limit the maximum number of returned rows > in a SQL Select (akin to the mysql LIMIT command?) > > I'm on universal server 9.13/solaris. > > Thanks > Philip > > yukonc@teleport.com