mysql show duplicate records

query to retrieve duplicate records - 

select column_name 

from table_name 

group by column_name 

having count(*) > 1 

order by column_name asc