select email
from
(
select email,count(email) as num
from person
order gy email
)as statistic //临时表
where num>1;
————————
select Email
from Person
group by Email
having count(Email) > 1;
本地链接数据库
异地登陆数据库%
cd C:\Program Files\MySQL\MySQL Server 5.7\bin
mysql -h 10.25.195.31 -u lenyi1 -p