I have a two column table. In column1 I have duplicate userID entries. In column2 the values are distinct with the exception of one or two. I want to get rid of all duplicate values in column1 and then make column1 a primary key. Before I get rid of them I'd like to identify all of the duplicate column1 values and place each record with a duplicate column1 value into a new temporary holding table. Can anyone provide me with a script to do this? All the scripts I have found assume both column1 and column2 have duplicates (a duplicate record) but this is mostly not the case for me. I'm only concerned with the duplicates in column1.