Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!pacbell.com!pacbell!pbhya!mspayer
From: mspayer@PacBell.COM (Mike Payer)
Newsgroups: comp.databases
Subject: Re: SQL Duplicate Row Deletion ???
Message-ID: <14367@pbhya.PacBell.COM>
Date: 3 Apr 91 05:13:38 GMT
References: <91091.141528SYSPMZT@GECRDVM1.BITNET>
Reply-To: mspayer@PacBell.COM (Mike Payer)
Organization: Pacific * Bell, San Ramon, CA
Lines: 24

In article <91091.141528SYSPMZT@GECRDVM1.BITNET> SYSPMZT@gecrdvm1.crd.ge.com writes:
>I've made a nice mistake loading data twice over several days into a table, and
>would like to delete just one of the duplicate rows.  The number of duplicates
>is on the order of 10,000 long rows, and the table has 250,000 rows total, so
>unloading, manipulating the data, and reloading the data is out of the
SOME STUFF DELETEDhhsolution to this problem?  The database manager is DB2, but
>
		SOME STUFF DELETED
>Phil Zampino

I just did the same thing about a week ago. I am using informix isql and some 
4gl. But what I did was run a select statement that gave me the row id number
and then deleted the row id for the duplicate entries. This worked fine for me
as I had about 1000 duplicate rows.

Hope this helps
      ____________________________________________________________
     /\                  Michael S Payer Jr                       \
     \_|     Administrator              FAX 415-867-0344          |
       |     Emergency Control Center   pacbell!pbecc!msp         |
       |                   pacbell!pbhya!mspayer                  |
       |                                                          |
       |   ____________SOMETIMES THE DRAGON WINS__________________|__
        \_/_________________________________________________________/