you can find duplicate records using having clause.please find the below mysql query to get duplicate records.
for example , i want to get duplicate mobile number from contact table.
"SELECT mobile, count(id) as total_count FROM contact GROUP BY mobile HAVING total_count > 1"