Re: Remove duplicate data in Oracle DB
From: david_g <david_l_gouldNOdaSPAM_at_yahoo.com.invalid>
Date: 2000/02/15
Message-ID: <0722a78c.93698565_at_usw-ex0106-048.remarq.com>#1/1
Date: 2000/02/15
Message-ID: <0722a78c.93698565_at_usw-ex0106-048.remarq.com>#1/1
In article <38A8FEA1.35D33056_at_email.sps.mot.com>, Noira Hadi
<r42317_at_email.sps.mot.com> wrote:
> I have tables in Oracle database which I could not enforce primary
> key
> due to unavoidable situation. Because of this, I might see
> duplications
> of data row.
> I want to know if it is possible for me to remove the duplicate
> row(s)?
> Appreciate any reply, reference or any tool that I could use to
> overcome
> this situation.
> Thanks in advance.
> Best Regards,
> hadi
Delete from mytable
where rowid not in
(select min(rowid) from mytable
group by keycolumn1,keycolumn2...keycolumnN)
/
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!