RE: removing duplicate records

From: Jackie Brock <jbrock_at_energyvelocity.com>
Date: Thu, 5 Aug 2004 10:16:53 -0700
Message-ID: <1ECF062C90A28640980C1BB8501D18E00DE099@mail01.corp.globalenergy.com>

Sorry about the extra characters... I love outlook...

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jackie Brock Sent: Thursday, August 05, 2004 11:05 AM To: oracle-l_at_freelists.org
Subject: RE: removing duplicate records

Try something like:

DELETE emp e1
WHERE EXISTS (SELECT 1 FROM emp e2=3D20

              WHERE e2.id =3D3D e1.id
		  AND   e2.rowid > e1.rowid)=3D20

HTH
-J

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Aug 05 2004 - 12:13:55 CDT