Re: Restricting queries to a certain number of rows?

Posted in 1996

"Tom Hogarty" — 18 Jun 1996 20:33:32 -0400 — source: Informix-list mailing list archive (1991-1998)

> On Jun 18, 4:17pm, Spetc@aol.com wrote: > ... > Does anybody know if it is possible to restrict the number of rows returned > by the Online engine (Version ?.?). Yes, in Release 8.0 (XPS) the sql syntax is extended so that SELECT FIRST 10... is made possible. Otherwise I only know of using a cursor and restricting your fetches to the required number of rows. Hope This Helps -- Tom Hogarty <Standard Disclaimers Apply> Performance Analyst Customer Benchmarking Pyramid Technology Corp North First Street San Jose CA95164