Pregunta de entrevista de RealPage
write a query to delete duplicate row from table
Respuesta de la entrevista
Anónimo
10 de feb 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;