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

Similar codes

9 votes155 views3 answers
Mysql get last id
SQL
1 vote176 views1 answer
Sqlite update from another table
SQL
2 votes155 views1 answer
Alter table add column and foreign key mysql
SQL
25 votes156 views3 answers
How to use a database to see tables mysql
SQL
11 votes149 views2 answers
Oracle all source
SQL
0 vote163 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote184 views1 answer
Sql basic commands
SQL
8 votes169 views2 answers
Oracle undo usage
SQL
4 votes178 views1 answer
Describe table mysql
SQL
6 votes163 views2 answers
Psql load dump
SQL