I'd like to delete duplicates from a SQL Server table. This is the query to show the duplicates:
SELECT Emp_Id, COUNT(Emp_Id) FROM TrainingLocal Where CourseId='164' GROUP BY Emp_Id HAVING COUNT(Emp_Id)>1
Would you please help me write a query that deletes the duplicates from this table?
I would really appreciate your help