查询表db_user_info中user_name重复的数据
SELECT * FROM db_user_info WHERE user_name IN (SELECT user_name FROM db_user_info GROUP BY user_name HAVING COUNT(1) > 1);
查询表db_user_info中user_name重复的数据
SELECT * FROM db_user_info WHERE user_name IN (SELECT user_name FROM db_user_info GROUP BY user_name HAVING COUNT(1) > 1);