mysql查询数据库重复

SELECT column_name1, column_name2, ...
FROM table_name
GROUP BY column_name1, column_name2, ...
HAVING COUNT(*) > 1;

SELECT t1.column_name1, t1.column_name2, ...
FROM table_name t1
INNER JOIN (
    SELECT column_name1, column_name2, ...
    FROM table_name
    GROUP BY column_name1, column_name2, ...
    HAVING COUNT(*) > 1
) t2 ON t1.column_name1 = t2.column_name1 
    AND t1.column_name2 = t2.column_name2
    ...

SELECT column_name1, column_name2, ...
FROM (
    SELECT column_name1, column_name2, ..., ROW_NUMBER() OVER(PARTITION BY column_name1, column_name2, ... ORDER BY column_name1) AS num
    FROM table_name
) t
WHERE num > 1;