Find duplicate records in a table

Find duplicate records in a table

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