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

 

Vlastimil Pošmura, 2019