分组、然后查看数量为一的。
select email from zzz_person group by email having count(*)>1
拓展一下:那么出现一次的呢? 看我眼睛
group by email having count(*)<2
分组、然后查看数量为一的。
select email from zzz_person group by email having count(*)>1
拓展一下:那么出现一次的呢? 看我眼睛
group by email having count(*)<2