摘要： 第一种方法select * from job_personal a where (select count(1) from job_personal where username=a.username and email=a.email)>1 order by pid第二种方式select * from job_personal where usernamein(select usernamefrom job_personal group by usernamehaving count(username)>1)order by usernameasc 阅读全文