Re: DELETE DUPLICATES

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.

-- 
Bruce Arbuckle                                    EMAIL: brucea_at_atlastele.com