查询mysql重复记录

查询字段重复：

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

 

posted @ 2017-12-24 22:32  maoriaty  阅读(95)  评论(0)  编辑  收藏  举报