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

19 votes125 views3 answers
Grant mysql
SQL
-1 vote114 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote139 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote109 views2 answers
Cascade syntax in sql
SQL
16 votes121 views2 answers
Add column if not exists mysql
SQL
3 votes124 views1 answer
Unsigned int in mysql
SQL
0 vote78 views1 answer
Mysql select top 2
SQL
10 votes146 views4 answers
Join multiple tables in sql
SQL
0 vote123 views1 answer
SQL column name Oracle
SQL
2 votes116 views1 answer
Add default sql server
SQL