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

9 votes178 views3 answers
Date format in sql
SQL
3 votes151 views3 answers
C# sql select
SQL
3 votes176 views2 answers
Search text in all sql server stored procedure
SQL
0 vote117 views1 answer
Oracle sql replace string in clob
SQL
0 vote144 views1 answer
First mysql
SQL
15 votes342 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote155 views1 answer
Db.Database.SqlQuery
SQL
1 vote145 views2 answers
How to check username in mysql command line
SQL
2 votes139 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote177 views1 answer
Sql server insert inner join
SQL