Re: Duplicate Records
From: Slava Natapov <Slava_Natapov_at_mail.stil.scitex.com>
Date: 1996/10/27
Message-ID: <3273F550.1151_at_mail.stil.scitex.com>#1/1
Date: 1996/10/27
Message-ID: <3273F550.1151_at_mail.stil.scitex.com>#1/1
Richard William Howell 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
Another solution:
select ename from emp
group by ename
having count(*) >1;
--Slava. Received on Sun Oct 27 1996 - 00:00:00 CEST