how to get the only duplicated record in mysql code example
Example 1: mysql get latest duplicate rows
SELECT
t1.primary_id,
t1.duplicate_id,
t1.data1,
t1.data2
FROM
table_name t1
LEFT JOIN table_name t2
ON (t1.duplicate_id = t2.duplicate_id AND t1.primary_id < t2.primary_id)
WHERE
t2.primary_id IS NULL
Example 2: mysql find duplicates in same table
SELECT t1.*
FROM tableName AS t1
INNER JOIN(
SELECT duplicateField
FROM tableName
GROUP BY duplicateField
HAVING COUNT(duplicateField) > 1
)temp ON t1.duplicateField = temp.duplicateField
order by duplicateField