with t as (
select p1.id as pid
from person as p1, person as p2
where p1.email = p2.email and p1.id > p2.id
)
delete person from person, t
where person.id = t.pid
Leetcode_196_删除重复的电子邮箱_SQL
最新推荐文章于 2022-07-25 10:01:06 发布