How to delete duplicate value from table in mysql?

Here is a siple query to delete duplicate value from table :

DELETE e1 FROM employee e1, employee e2 WHERE e1.name = e2.name AND e1.id > e2.id;