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

12 votes314 views4 answers
How to check mysql version ubuntu
SQL
1 vote273 views1 answer
Mysql history command
SQL
2 votes280 views1 answer
Sql skip the first row
SQL
0 vote313 views2 answers
Select last 30 days sql
SQL
9 votes538 views2 answers
Current date in postgresql minus 1 day
SQL
8 votes300 views1 answer
Check mysql version phpmyadmin
SQL
6 votes300 views2 answers
Postgresql pg_dump
SQL
0 vote275 views1 answer
On update current_timestamp jpa
SQL
1 vote289 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote290 views1 answer
SQL date part only of datetime
SQL