Re: Duplicate Records

Something like this should help:   

 select owner,table_name,rowid
   from zdba_tables a
   where exists
   (select 1 from zdba_tables
   where a.owner = b.owner
   and a.table_name = b.table_name
   and a.rowid <> b.rowid)

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