Re: remove dups

Posted in 2000

Mark D. Stock — Mon, 26 Jun 2000 22:37:00 +0100 — source: Informix-list mailing list archive (1991-1998)

pauleccleston@my-deja.com wrote: > > SELECT id, min(text) from table group by id Nice thought, but MIN requires (or at least always used to require) a numeric argument. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+