Re: Duplicat keys
Reply to: RE>Duplicat keys
You can run an sql statement such as:
select colname from tabname
group by colname having count(*) > 1
This will give you records with duplicate values in your column. If you
where creating a unique key on multiple columns, you can revise this
sql to look something like:
select colname1, colname2, colname3, . . . from tabname
group by colname1, colname2, colname3, ... having count(*) > 1
I hope this helps,
Dave Mascorro
dave@oncology.uthscsa.edu
--------------------------------------
Date: 10/24/94 9:20 AM
To: David Mascorro
From: sheltra@emh-1.submepp.navy.mil
I have a problem:
While creating a "unique key index" on a file of about
190k records I have incurred a duplicate record. How do I
find the record(s) with the duplicate key?
We are running Oline 5.0
4gl 4.10
sql 4.10
Thanks in advance for any help.
My e-mail: sheltra@emh-l.submepp.navy.mil