196. 删除重复的电子邮箱（MySQL）（删除表中某列值重复的数据）

1 题目

2 MySQL

2.1 方法一

delete p1
from Person as p1, Person as p2
where p1.Email = p2.Email AND p1.Id > p2.Id;