题目描述:查找下表中Email重复的Email
使用group by:
select Email
from Person
group by Email
having count(*) > 1
普通方法:
select distinct p1.Email
from Person p1, Person p2
where p1.Email = p2.Email and p1.Id != p2.Id
题目描述:查找下表中Email重复的Email
使用group by:
select Email
from Person
group by Email
having count(*) > 1
普通方法:
select distinct p1.Email
from Person p1, Person p2
where p1.Email = p2.Email and p1.Id != p2.Id