• Can be done using temp table for your reference

    SELECT EmpID,EmpName INTO #temp

    FROM Employees

    GROUP BY EmpID,EmpName

    HAVING COUNT(*)>1

    DELETE Employees FROM Employees a INNER JOIN #temp b ON

    a.EmpID=b.EmpID

    INSERT INTO Employees(EmpID,EmpName)

    SELECT EmpID,EmpName FROM #temp