Re: Duplicate Records
From: John P DeVoy <devoy_at_next.com>
Date: 1996/10/24
Message-ID: <54ou4e$md7_at_news.next.com>#1/1
Date: 1996/10/24
Message-ID: <54ou4e$md7_at_news.next.com>#1/1
In article <326FE2E4.7086_at_indy.net> Richard William Howell <rwh_at_indy.net>
writes:
> 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
select a.*, b.*
from table a, table b --- the same table, joined to itself
where a.key = b.key
and a.rowid < b.rowid
This will work,
- John De Voy DBA, NeXT Software