Appinventiv interview question
6 Remove Duplicates rows from table
Interview Answer
Anonymous
26 Oct 2018
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));
6 Remove Duplicates rows from table
Anonymous
DELETE FROM EmployeeSalary WHERE EmpId IN ( SELECT EmpId FROM EmployeeSalary GROUP BY Project, Salary HAVING COUNT(*) > 1));
Check out your Company Bowl for anonymous work chats.