第一种方法
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 username
in(select username from job_personal group by username having count(username)>1)
order by username asc