Re: Does Informix have a ROWCOUNT thing like Sybase to limit returned

Posted in 1999

Sujit.Pal@BankAmerica.com — Tue, 08 Jun 1999 17:22:35 -0700 — source: Informix-list mailing list archive (1991-1998)

Fuzzy In 7.3 and above to get the first 10 rows, for example: SELECT FIRST 10 colname, colname,... FROM tabname; HTH Sujit granta@nospam.student.canberra.edu.au (Fuzzy) on 06/07/99 09:21:32 PM Please respond to granta@nospam.student.canberra.edu.au (Fuzzy) To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Does Informix have a ROWCOUNT thing like Sybase to limit returned rows Subject says it all Ciao Fuzzy :-)