根据字段分组之后条件判断个数大于1 SQL: SELECT u.id,u.id_card,u.mobile_number FROM `user` u GROUP BY u.id_card HAVING COUNT(*) > 1;