how to delete duplicate record from table

Question

My question from sql server 2008 if i have many duplicate record in table.i want to remove duplicate record from table . please tell me how to check that i have duplicate record or not and then delete those record .

Amit Singh · Answer

http://www.dotnet-tricks.com/Tutorial/sqlserver/IL3S290812-Remove-duplicate-records-from-a-table-in-SQL-Server.html https://support.microsoft.com/en-us/kb/139444

Amit Aggarwal · Answer

Check for duplicate on basis of some condition. Say if I want to check for Employee ID duplication then query will be like: Select EmployeeID Count(*) as Occurence from Employee Group by EmployeeID having Count(*)> 1 The above will give you EmployeeID will occurence if it is greater 1