Re: complex duplicate row
On 17 Dec 2005 07:59:02 -0800, adrian.baceanu@gmail.com
<adrian.baceanu@gmail.com> wrote:
> But how to select duplicate rows (identical in all the columns, except
> codfisc) and in the same time the result also to include this column,
> codfisc?
SELECT INDISTINCT ... ?
:-)
SELECT ...unique columns... FROM f103 HAVING COUNT(*) > 1 INTO TEMP t;
SELECT * FROM f103
WHERE EXISTS (SELECT * FROM t WHERE t.col1 = f103.col1 AND ...);
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
sending to informix-list