如何在SQL 2021中选择重复行

SELECT column1, column2, COUNT(*)
FROM table
GROUP BY column1, column2
HAVING COUNT(*) > 1;

SELECT column1, column2
FROM (
    SELECT column1, column2, ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY column1) AS rn
    FROM table
) AS t
WHERE rn > 1;

SELECT t1.column1, t1.column2
FROM table t1
JOIN table t2 ON t1.column1 = t2.column1 AND t1.column2 = t2.column2
WHERE t1.id <> t2.id;