The normal way to do it would be to copy the UNION of the table with itself (to remove duplicates) to a temp table, truncate the table, then move the data back.