Hi...

I usually clean up my "mess" with "something" like this

delete from myTable where myID NOT in

(select min(MyID) from myTable group by myUniqueField)

But I think the best application for CTE are recursive querries...