duplicate row in mysql

Please help me to solve my problem related to duplicate rows in mysql through php code.

i have table with four column. in which we need to check three column for uniqueness (A, B, C). D will not take part in checking of duplicate rows

for e.g.

A     B    C    D
1     2    3    1
1     2    3    3
1     3    2    3
2     3    1    2

i want to delete duplicate rows from table and insert it to another table. so we left unique rows in our table.

table will be 

A B C D
1 3 2 3
2 3 1 2

another table will be 
A B C D
1 2 3 1
1 2 3 3