oracle – Najít duplicity v tabulce

Od posmura

select 
      column_name, 
      count(column_name) 
from 
      table 
group by 
      column_name 
having 
      count (column_name) > 1;