查询数据库某个字段重复出现的数据

select card_id,count(*) as count from mer_verify_card group by card_id having count>1;

SELECT
*
FROM
mer_verify_card
WHERE card_id IN
(SELECT
card_id
FROM
mer_verify_card
GROUP BY card_id
HAVING COUNT(1) > 1)