MySQL find duplicate reccords

This is show you when you want to find duplicate reccord on MySQL .

select address, count(impt_key) as count_impt
from table
group by impt_key
having count_impt > 1
order by count_impt;