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 vote160 views1 answer
How to check event scheduler status mysql
SQL
1 vote138 views1 answer
Mariadb alter user host
SQL
1 vote136 views1 answer
Right outer vs left outer join
SQL
0 vote130 views1 answer
Mysql show category once count how many products
SQL
0 vote135 views1 answer
Mysql export search results
SQL
0 vote167 views1 answer
Alter domain sql
SQL
4 votes133 views2 answers
Truncate oracle
SQL
0 vote144 views2 answers
Timing sql queries
SQL
0 vote140 views2 answers
What is 1=2 in sql
SQL
0 vote95 views1 answer
Select mysql limit to 2 decimal places
SQL