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 vote309 views1 answer
Python escape mysql
SQL
12 votes299 views4 answers
Install mysql ubuntu 18.04
SQL
22 votes323 views4 answers
Mysql date_format
SQL
2 votes296 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote312 views1 answer
How to tell if i have lactose intolerance
SQL
1 vote302 views1 answer
Oracle convert run duration to number
SQL
1 vote278 views1 answer
Select random sample sql
SQL
0 vote349 views1 answer
Traccar mysql
SQL
0 vote284 views1 answer
Generate sequence number in sql server
SQL
31 votes292 views3 answers
Sql count
SQL