Re: How to get the first row in a selection of rowS

Posted in 2003

Mark D. Stock — Wed, 15 Oct 2003 19:37:54 +0100 — source: Usenet: comp.databases.informix

John Carlson wrote: > On Tue, 14 Oct 2003 17:00:40 +0100, "Andrew Hardy" > <Andrew.Hardy@marconi.com> wrote: > >>I have a select statement whch retrieves a number of rows. Given the >>underlying condition, I want the fastest way just to get the first of the >>selected rows. > > I don't see an Informix engine version. . . but is it possible to use > the "select first" syntax??? Not forgetting to use SET OPTIMIZATION FIRST_ROWS as well. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list