Question d’entretien chez Appinventiv
6 Remove Duplicates rows from table
Réponse à la question d'entretien
Utilisateur anonyme
26 oct. 2018
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));