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 vote267 views1 answer
ORACLE PARSE STRING
SQL
0 vote271 views1 answer
How to add boolean column in postgresql
SQL
1 vote280 views1 answer
Influxdb export to csv
SQL
0 vote273 views1 answer
Add multiple field in table sql
SQL
0 vote318 views1 answer
Sql query to select even numbers
SQL
34 votes264 views6 answers
Sql change data type
SQL
5 votes246 views1 answer
List foreign key oracle
SQL
0 vote277 views1 answer
Sqlite version check
SQL
0 vote292 views3 answers
Postgres date difference seconds
SQL
9 votes281 views6 answers
Check constraint in sql
SQL