remove duplicates

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Wed, 28 Jul 2010 11:14:25 -0600
Message-ID: <AANLkTi=uhuU7dC+XrSZstozhiDE+Ffw6=NUzgm84bzPU_at_mail.gmail.com>

oracle 9.2.0.7 on linux
I have some duplicated records in a table (woe_fact_barb) I cannot come up with the sql to remove these. Can anyone help? The only way to identify the duplicate is that there are 2 records with the same WO_SID.

   WOE_SID WO_SID INVC_AMT
---------- ---------- ----------

   1079559  177694790     7898.1
   1080085  177694790     7898.1
   1079589  177694810   24026.19
   1079663  177694810   24026.19

   1079567 177694858 17088.35
   1080135 177694858 17088.35

I've tried various combinations of sql sorta like this:

sql>delete from woe_fact_barb
  2 (select min(woe_sid)
  3 from woe_fact_barb )
  4 where wo_sid=177694790
  5 /

Nothing I've tried is close.
thanks for any help!
Barb

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 28 2010 - 12:14:25 CDT