Sollicitatievraag bij Appinventiv
6 Remove Duplicates rows from table
Antwoord op sollicitatievraag
Anoniem
26 okt 2018
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));
6 Remove Duplicates rows from table
Anoniem
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));