Re: Eliminating duplicates
Date: Wed, 20 Apr 1994 12:18:05 GMT
Message-ID: <patinoj.6.000D4D92_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
Try using the ROWID
Example select rowid, column1, colum2
from table;
Hope this helps Received on Wed Apr 20 1994 - 14:18:05 CEST