查询mysql重复记录

查询字段重复：

SELECT count(*),msg from awardperson a WHERE a.msg in (SELECT msg from awardperson GROUP BY msg HAVING count(*)>1)