write a query to delete duplicate row from table

Question

shivam baghel · Accepted Answer

DELETE e1 
FROM employees e1
INNER JOIN employees e2 
WHERE 
    e1.id > e2.id AND 
    e1.name = e2.name AND 
    e1.department = e2.department;

RealPage

Domanda di colloquio di RealPage

Risposta di colloquio

Aziende seguite

Ricerche di lavoro