Re: Eliminating duplicates

From: Jose Patino <patinoj_at_merlin.incae.ac.cr>
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

Original text of this message