问题
答案
Select Email from (Select Email , count(Email) as num from Person group by Email)as anything where num > 1;
解析
本体需要写个子表,获取有每个email有多少个,再输出多的即可。
Select Email from (Select Email , count(Email) as num from Person group by Email)as anything where num > 1;
本体需要写个子表,获取有每个email有多少个,再输出多的即可。