Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!zaphod.mps.ohio-state.edu!rpi!crdgw1!gecrdvm1!syspmzt
From: SYSPMZT@gecrdvm1.crd.ge.com
Newsgroups: comp.databases
Subject: SQL Duplicate Row Deletion ???
Message-ID: <91091.141528SYSPMZT@GECRDVM1.BITNET>
Date: 1 Apr 91 18:15:28 GMT
Organization: General Electric Corporate Research & Development
Lines: 13

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
question.  I can identify the duplicate rows with a select joining the table
to itself, but I can't use the same technique to delete the rows.

Anyone have a nifty solution to this problem?  The database manager is DB2, but
I'd think that any SQL based language would have the same problem.

Thanks in advance,

Phil Zampino