Refer my article Remove duplicate records/data from Sql Server database table http://www.webcodeexpert.com/2013/11/how-to-remove-duplicate-recordsdata.html

There is multiple way to remove duplicate record Please refer my article http://www.c-sharpcorner.com/UploadFile/ff2f08/delete-duplicate-data-in-sql-server/