题目来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/duplicate-emails
我的解答:
select distinct(p1.Email) from Person as p1,Person as p2 where p1.Id>p2.Id and p1.Email=p2.Email
题目来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/duplicate-emails
我的解答:
select distinct(p1.Email) from Person as p1,Person as p2 where p1.Id>p2.Id and p1.Email=p2.Email