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 vote214 views1 answer
How to convert external table to managed table in hive
SQL
5 votes266 views1 answer
Migrate sql table another database
SQL
1 vote223 views1 answer
Mysql view current queries
SQL
0 vote188 views1 answer
Backup a table in sql
SQL
0 vote165 views1 answer
Create duplicate table postgres
SQL
0 vote207 views1 answer
Clone table structure mysql
SQL
1 vote241 views1 answer
How to give access to database in postgresql server to another user
SQL
3 votes196 views1 answer
Oracle wait
SQL
0 vote224 views1 answer
Psql generate id in existing database
SQL
0 vote195 views1 answer
How much table store postgres
SQL