Home

Jan 17, 2011

Find duplicate records in a MYSQL table

This query will help you to find duplicate records in a MYSQL table...

Category: MySQL

Posted by: Admin

select name, count(name) as cnt
 from companies
 group by name
 having cnt > 1
 order by cnt;