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

4 votes255 views2 answers
REST API
SQL
0 vote262 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote261 views1 answer
Create table with float datatype in sql server
SQL
0 vote236 views1 answer
Sort by last two number sql
SQL
0 vote259 views1 answer
How to execute stored output to csv files
SQL
0 vote239 views1 answer
How to remove default in mysql
SQL
0 vote251 views1 answer
Events not working db
SQL
8 votes263 views2 answers
Safe update mode in mysql
SQL
0 vote259 views1 answer
Find and replace database table phpmyadmin
SQL
3 votes262 views2 answers
Mysql config user password
SQL