Re: Q: Find end delete duplicate values?

Try this :

delete from tablename t1, tablename t2
where t1.indexed_field = t2.indexed_field and t1.indexed_field_2 = t2.indexed_field_2 and ... (repeat for all of the indexed fields) and t2.rowid > t1.rowid

by indexed_field I am referring to the fields which will define your unique index (or, the ones that define your duplicate rows)

--John Received on Sun Feb 07 1999 - 21:26:54 CST