解法有三种,这种比较简单,就直接上代码了:
#1.自连接 进行条件赛选
SELECT * FROM person p1,person p2
WHERE p1.id != p2.id AND p1.email = p2.email
#2.求数量在判断
SELECT * FROM person GROUP BY email HAVING COUNT(email) > 1
#3.虚表方法
select
email
from
(select count(1) as t,email from person group by email)r where r.t>1;