题目
方法一(group by和having):
Select Email from Person group by Email having count(Email)>1;
结果:
方法二(临时表):
临时构造一个只包含Email和重复次数cou的表。
select a.Email from (select Email,count(Email) as cou from Person group by Email) as a where cou > 1;
结果:
题目
方法一(group by和having):
Select Email from Person group by Email having count(Email)>1;
结果:
方法二(临时表):
临时构造一个只包含Email和重复次数cou的表。
select a.Email from (select Email,count(Email) as cou from Person group by Email) as a where cou > 1;
结果: