Re: Duplicate Records

Here she is:

select a.employee_num, b.employee_num

   from emp a, emp b where
   a.employee_num = b.employee_num
   and a.rowid <> b.rowid;

Hope this helps, Rob.

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