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

17 votes322 views2 answers
Mysql date to string
SQL
0 vote520 views1 answer
The differnece between to values in sql
SQL
32 votes341 views6 answers
Insert select
SQL
2 votes322 views1 answer
Sqlite3 show columns name
SQL
0 vote308 views2 answers
How to relationship query two different tables in MySQL
SQL
7 votes327 views3 answers
Sql server reset auto increment
SQL
5 votes333 views2 answers
Create table mysql example auto_increment
SQL
10 votes295 views2 answers
Mysql select timestamp group by day
SQL
1 vote551 views1 answer
Postgres convert text to number
SQL
1 vote336 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL