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

RealPage Interview Question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches