主要用到group by与having select Person.Email from Person group by(Person.Email) having count(Person.Email)>1;