Pergunta de entrevista da empresa Appinventiv
6 Remove Duplicates rows from table
Resposta da entrevista
Sigiloso
26 de out. de 2018
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));