Re: SQL: How to select first N rows?

Bill Ennis wrote: > > I believe in version 7.23 there is. > The fetaure is called first rows optimization. No. Those are TWO new features in version 7.3. First row optimisation is something different and was in version 7.10.UD1. ;-) This optimises the query to return the first few rows quickly. The question was about returning ONLY the first few rows. I think. x-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+