Re: Eliminating duplicates
Date: Wed, 20 Apr 1994 12:20:52 GMT
Message-ID: <patinoj.7.000D5977_at_merlin.incae.ac.cr>
In article <1994Apr19.215930.1228_at_rat.csc.calpoly.edu> mbhatt_at_galaxy.csc.calpoly.edu (Manish J. Bhatt) writes:
>From: mbhatt_at_galaxy.csc.calpoly.edu (Manish J. Bhatt)
>Subject: Eliminating duplicates
>Date: Tue, 19 Apr 94 21:59:30 GMT
>Is there a way to remove duplicate records from a table? I did an
>import from a backup three times, and I didn't realize that each time
>it would add in another copy of a record. I can't go back to the
>backup because new data has been added since then.
>Thanks,
>Manish
>---------------------------------------------------------------------------
>Manish J. Bhatt Administrative Systems
>AIX Systems Administrator California Polytechnic State University
>mbhatt_at_dtvrut.infsys.calpoly.edu S a n L u i s O b i s p o
Sorry, my last message was incomplete
After the select, then for each record you want to delete do
delete from table where rowid = "the row id of the select";Received on Wed Apr 20 1994 - 14:20:52 CEST