当前位置：网站首页>Leetcode:196. delete duplicate email

Leetcode:196. delete duplicate email

2022-07-22 18:58:00 【A master of East and West】

This question is very wonderful https://leetcode-cn.com/problems/delete-duplicate-emails/
Official explanation ：

DELETE p1 FROM Person p1,
    Person p2
WHERE
    p1.Email = p2.Email AND p1.Id > p2.Id;

Be careful ：
1,delete When there are two tables in the statement , The table to delete records is located in delete and from Between , And you need the table alias
2, With p1 Of Email To connect p2 Of Email As an association key , And directly compare Id Size ,p2.Id It has always been the smallest Id,p1 The rows of the table are decreasing , and p2 Table will not .

原网站

版权声明
本文为[A master of East and West]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207220911019515.html