leetcode_Oracle_182. 查找重复的电子邮箱

182. 查找重复的电子邮箱

---

select Email as "Email" from (
select Email,count(1) as counts
from Person
group by Email) temp where temp.counts>1;


select distinct a.Email as "Email" from Person a,Person b 
where a.Email=b.Email and a.Id<>b.Id;


select distinct a.Email as "Email" from Person a, Person b 
where a.Email = b.Email and a.Id != b.Id;


select Email as "Email" from Person group by Email having count(Email)>1 ;