SQL query to compare two columns in the same table

Question

I have a table where some of the data are repeating. I need to copy the repeated values from the table to a new table. 

Need an sql query to do this