RE: Find a duplicate value via SQL
Try something like this :
SELECT field,count(*)
FROM table
WHERE conditios
GROUP BY field
HAVING count(*) > 1
The last part of the select is for duplicates. I hope this helps you.
-----Mensaje original-----
De: Tim_Clifton@candle.com <Tim_Clifton@candle.com>
Para: informix-list@iiug.org <informix-list@iiug.org>
Fecha: Martes 15 de Septiembre de 1998 10:09 PM
Asunto: Find a duplicate value via SQL
>
>
>
>Hello,
>
> This is undoubtedly a pedestrian question to some of you, but as I am
>new to SQL...... Does anyone know of a quick way to find records that
>contain duplicate values for a particular field via SQL? Or is this done
>is SPL?
>TIA
>
>
>