Find duplicate records

Submitted by:Andery Smith

Date added:24 August, 2013

Category:MySQL

MySQL code to find duplicate records in table

Tags: find duplicate , find record

Code Snippet:

    SELECT id, COUNT(*) as n
FROM my_table
GROUP BY id
HAVING n >1;
 
 

Comments