LeetCode - Delete Duplicate Emails
Discription:Write a SQL query to delete all duplicate email entries in a table named Person
, keeping only unique emails based on its smallest Id.
删除重复的Email地址,保留Id最小的那个。
使用自身连接循环即可。
# Write your MySQL query statement below delete p1 from Person p1, Person p2 where p1.Email=p2.Email and p1.Id>p2.Id;
作者:Pickle
声明:对于转载分享我是没有意见的,出于对博客园社区和作者的尊重一定要保留原文地址哈。
致读者:坚持写博客不容易,写高质量博客更难,我也在不断的学习和进步,希望和所有同路人一道用技术来改变生活。觉得有点用就点个赞哈。