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

2 votes181 views1 answer
Postgresql update sequence next value
SQL
2 votes185 views1 answer
Alter table add column and foreign key mysql
SQL
2 votes172 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote171 views1 answer
Mysql set boolean default value
SQL
0 vote174 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote167 views1 answer
Drop all procedures sql server
SQL
2 votes161 views1 answer
Create table with primary key
SQL
22 votes175 views4 answers
Tsql rename table
SQL
1 vote177 views1 answer
Sql server loop over query
SQL
0 vote160 views2 answers
Mysql multiply
SQL