56,875
社区成员




#查询重复的user_id_number
SELECT
a.user_id,
a.user_name,
a.user_id_number
FROM
user_info a
INNER JOIN (
SELECT
user_id_number
FROM
user_info
WHERE
user_id_number <> ''
GROUP BY
user_id_number
HAVING
COUNT(1) > 1
) b ON a.user_id_number = b.user_id_number
ORDER BY
user_id_number
别用in,改用inner应该会快点