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

0 vote346 views1 answer
Sql server check whether column has same equal values
SQL
1 vote342 views1 answer
Sql restore backup query
SQL
0 vote333 views1 answer
Mysql pad zeros
SQL
0 vote345 views1 answer
Stored function in sql
SQL
8 votes361 views2 answers
Phpmyadmin default password
SQL
4 votes338 views2 answers
Show all database inside postgresql
SQL
3 votes333 views3 answers
Into in sql
SQL
2 votes343 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote329 views1 answer
How to find top 3 salary in sql
SQL
-1 vote327 views3 answers
Check table exist postgresql
SQL