196. 删除重复的电子邮箱

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

MySQL

# Write your MySQL query statement below
DELETE p1
FROM person p1 join person p2
ON p1.email = p2.email AND p1.id > p2.id