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

3 votes199 views1 answer
Mysql replace string in table
SQL
0 vote245 views2 answers
Insert data into multiple tables mysql
SQL
0 vote195 views1 answer
Add alternate add column sql
SQL
1 vote191 views3 answers
How to filter repeated same result using sql query
SQL
1 vote221 views2 answers
Mysql extract number from string
SQL
0 vote187 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote197 views1 answer
Top frequency in sql server
SQL
0 vote202 views1 answer
Mysql drop vs delete
SQL
0 vote220 views1 answer
How to join result table in mysql
SQL
0 vote153 views0 answer
SQL