Greetings, I am trying to remove duplicate records from a table but preserving one of them using temp tables/etc. Pretty much removing duplicates but leaving one of the identical sets. Example DATA would like like: col1, col2, col3 20, 1090, bad 22, 1090, bad 25, 1090, bad 28, 1091, good 2350, 2444, bad 2353, 2444, bad 2370, 2444, bad 3000, 5000, good 3005, 5001, good AFTER the DELETE sql (which I need help with) example data (based off of above) should look like col1, col2[/ col3 20, 1090, bad 28, 1091, good 2350, 2444, bad 3000, 5000, good 3005, 50001, good Please notice that one of each of the sets that had duplicates remains. The records the new sql would need to focus on would be records on col2 With counts(col2) >1 should not have two col2's with data like 1090. All but one of them would need to be deleted. Doesnt matter which one is left. Please help!