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

1 vote304 views1 answer
Add multiple row table pl sql
SQL
1 vote308 views1 answer
How to select random rows from a table
SQL
0 vote307 views1 answer
List all indexes postgres
SQL
1 vote299 views1 answer
Use of now() in mysql
SQL
3 votes297 views1 answer
Mysql set field unique
SQL
1 vote325 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote312 views1 answer
Grant privileges of databse to user
SQL
0 vote312 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote286 views1 answer
Denormalise SQL command
SQL
0 vote289 views1 answer
Oracle job class
SQL