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

-1 vote105 views1 answer
How to open blade file from blade in laravel
SQL
-2 votes112 views1 answer
No module named '_sqlite3
SQL
16 votes106 views6 answers
Install sqlite3 python
SQL
0 vote111 views1 answer
Multiple tricky query in sql server
SQL
0 vote115 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote115 views1 answer
Sqlite update where exists
SQL
0 vote120 views2 answers
Sql query print strings and int
SQL
0 vote111 views2 answers
Sql searching via key word
SQL
3 votes108 views2 answers
Enter mysql command line
SQL
0 vote107 views1 answer
How to delete python anywhere mysql database
SQL