显示PLSQL中不唯一的记录的方法

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

SELECT column1, column2, COUNT(*) OVER (PARTITION BY column1, column2) AS record_count
FROM table_name
WHERE record_count > 1;

SELECT column1, column2
FROM table_name
WHERE (column1, column2) IN (SELECT column1, column2 FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1);