这个屌丝很懒，什么也没留下！

[LeetCode]--196. Delete Duplicate Emails

作者：小惠珠哦 | 2024-07-08 18:00:51

DELETE p FROM Person p, Person q WHERE p.Id>q.Id AND q.Email=p.Email 1

DELETE FROM Person WHERE Id NOT IN ( SELECT A.Id FROM (SELECT Min(Id) as Id FROM Person GROUP BY Email) A )1

Another Clear Form:

DELETE FROM Person
WHERE Id NOT IN (
  SELECT * FROM (
    SELECT Min(Id)
    FROM Person
    GROUP BY Email
  ) Tmp
)1
2
3
4
5
6
7
8

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小惠珠哦/article/detail/799636