Pergunta de entrevista da empresa RealPage
write a query to delete duplicate row from table
Resposta da entrevista
Sigiloso
10 de fev. de 2025
DELETE e1 FROM employees e1 INNER JOIN employees e2 WHERE e1.id > e2.id AND e1.name = e2.name AND e1.department = e2.department;