RE: max rows

Posted in 1999

David Tamburin — Thu, 29 Jul 1999 04:43:19 -0400 — source: Informix-list mailing list archive (1991-1998)

Philip, You can do a: select first n (rest of select statement);n being the number of rows you want returned. regards, David Tamburin david.tamburin@protegrity.com -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of mission critical Sent: Thursday, July 29, 1999 2:37 PM To: informix-list@iiug.org Subject: max rows 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