mysql查询表里的重复数据 使用详情说明

先贴个简单的SQL语句

select username,count(*) as count from hk_test group by username having count>1;