Re: Number of rows

Posted in 1999

Chuck Renaud — Mon, 15 Feb 1999 12:07:23 -0600 — source: Informix-list mailing list archive (1991-1998)

> I'd like to limit the the number of rows of a query. Is there something > equivalent to 'Set RowCount' with Informix ? You don't indicate which version of the engine you're using. You may be able to use SELECT FIRST x. Not sure if it's in 8 or 9, but it's available in 7.3. --Chuck Renaud