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 vote336 views1 answer
Mysql update from select on same table
SQL
0 vote326 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote313 views1 answer
Flask sqlalchemy decimal
SQL
1 vote311 views1 answer
Not exists mysql
SQL
1 vote317 views1 answer
Oracle split string
SQL
1 vote342 views1 answer
Postgresql append array
SQL
14 votes349 views2 answers
Oracle limit rows
SQL
18 votes335 views6 answers
Creating table in MySQL
SQL
10 votes347 views4 answers
Else if mysql
SQL
-1 vote316 views3 answers
Update mongodb version ubuntu
SQL