查找表中id重复的行的所有数据

SELECT *
FROM a
WHERE id IN (
    SELECT id
    FROM a
    GROUP BY id
    HAVING COUNT(id) > 1
);