题意:查找出现一次以上的邮箱
题目链接:https://leetcode.com/problems/duplicate-emails/
select distinct x.Email /*这里主要要加上distinct*/
from Person as x, Person as y
where x.id != y.id and x.Email = y.Email;
题意:查找出现一次以上的邮箱
题目链接:https://leetcode.com/problems/duplicate-emails/
select distinct x.Email /*这里主要要加上distinct*/
from Person as x, Person as y
where x.id != y.id and x.Email = y.Email;