RE: Find a duplicate value via SQL
Hi Tim,
Try the following:
select col_name, count(*)
from table_name
having count(*) > 1
group by col_name;
Regards,
David Ashby
-----Original Message-----
From: Tim_Clifton@candle.com
[mailto:Tim_Clifton@candle.com]
Sent: Wednesday, 16 September 1998 10:01
To: informix-list@iiug.org
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