Re: Duplicate Records
From: Ted Goulden <gouldent_at_cadvision.com>
Date: 1996/10/25
Message-ID: <54phln$396o_at_elmo.cadvision.com>#1/1
Date: 1996/10/25
Message-ID: <54phln$396o_at_elmo.cadvision.com>#1/1
Try:
select t1.key
from table t1
where t1.rowid >
(select min(rowid)
from table t2
where t2.key = t1.key)
Its painfully slow for sizable tables but it works.
Richard William Howell <rwh_at_indy.net> wrote:
>I am trying to write a query which will extract a list of duplicate rows
>in my table so that I may examine the duplicate records and eliminate
>the "bad" one or more. Any suggestions appreciated.
>
>____________________________________________
>Richard W. Howell E-mail: rwh_at_indy.net
Received on Fri Oct 25 1996 - 00:00:00 CEST