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

11 votes205 views6 answers
Mysql else if
SQL
0 vote188 views1 answer
Reindex mssql table
SQL
0 vote165 views1 answer
Stuff in sql server
SQL
4 votes170 views1 answer
To date oracle with time
SQL
1 vote186 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote186 views2 answers
Functions with parameters SQL
SQL
0 vote200 views1 answer
Having all mysql
SQL
1 vote179 views1 answer
Mysql tables max count
SQL
0 vote186 views1 answer
Psql attribute cannot login
SQL
1 vote177 views3 answers
Default password of mysql
SQL