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 vote196 views1 answer
Xampp mysql version
SQL
10 votes154 views2 answers
Sql where clause multiple values
SQL
60 votes555 views6 answers
Add column in sql
SQL
1 vote192 views1 answer
Search for tables with name postgresql
SQL
0 vote187 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
6 votes220 views5 answers
Oracle list tablespaces
SQL
0 vote176 views1 answer
Find usage of table in sql server
SQL
25 votes211 views6 answers
How to change column name in mysql
SQL
0 vote207 views1 answer
Mysql where in maintain order
SQL
0 vote195 views1 answer
Load utilities in sql server
SQL