Register now or log in to join your professional community.
https://support.microsoft.com/en-us/help/139444/how-to-remove-duplicate-rows-from-a-table-in-sql-server
or
https://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows
I prefer the second one
Good luck.