如何在Oracle中的表中找到重复值？

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

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