RE: Find a duplicate value via SQL
Tim,
select count(*) count, field
from tablename
group by 2
having count (*) > 1
Regards.
Fernando
+----------------------------------------------------------------+
Fernando Collalti mailto:fernando.collalti@orbit.net
Database Administrator http://fcolla.orbit.net
Orbit Communications Company http://www.orbit.net
Via Raffaele Costi, 60 Tel: +39 06 22543474
I-00155 Rome Fax: +39 06 22543810
ITALY Mob: +39 335 8373864
+----------------------------------------------------------------+
-----Original Message-----
From: Tim_Clifton@candle.com [mailto:Tim_Clifton@candle.com]
Sent: Tuesday, September 15, 1998 5:01 PM
To: informix-list@iiug.org; Collalti, Fernando
Subject: 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