# 196. Delete Duplicate Emails

https://leetcode.com/problems/delete-duplicate-emails/

```mysql
#11:35
DELETE personTable1 FROM person AS personTable1
INNER JOIN person AS personTable2
WHERE personTable1.id > personTable2.id AND personTable1.email = personTable2.email;  
#11:50
```

Runtime: 1287 ms, faster than 5.00% of MySQL online submissions for Delete Duplicate Emails.

Memory Usage: 0B, less than 100.00% of MySQL online submissions for Delete Duplicate Emails.