Re: DELETE DUPLICATES

In article <1993Jun16.000109.3764_at_ml.csiro.au> jstander_at_ml.csiro.au writes:
>In article 3047_at_atlastele.com, brucea_at_atlastele.com (Bruce Arbuckle) writes:
>>In article <1va9pm$7mc_at_erau.db.erau.edu> mellott_at_db.erau.edu (David Michael Mellott) writes:
>>>does anyone have a simple script to delete duplicates
>>>from a table
>>>I thank you in advance\mike
>>>.
>>>
>>delete from table
>> where rowid in
>> (select rowid from table A, table B
>> where B.rowid > A.rowid)
>>
>>Should do the trick.
>>
>
>
>Actually, Bruce's solution didn't work at all when I tested it.

Your right! I had just recently used what I posted (prior to posting), but HAD used the a.key = b.key and left it out of the posting as I was doing it from memory. Sorry! I'll pull up the code next time so that I don't rely on my "memory".

-- 
Bruce Arbuckle                                    EMAIL: brucea_at_atlastele.com