先贴个简单的SQL语句 select username,count(*) as count from hk_test group by username having count>1; 使用详情说明 转载于:https://www.cnblogs.com/userzf/p/10827737.html