mysql中查询重复的记录

SELECT username, COUNT(*) AS COUNT FROM honghai_user GROUP BY username HAVING COUNT>1;