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 vote232 views1 answer
How to compile a function in oracle
SQL
0 vote185 views1 answer
Get who is hired in february in sql
SQL
3 votes210 views2 answers
Synonym oracle
SQL
1 vote199 views1 answer
Mysql find tables with column name
SQL
0 vote185 views2 answers
How covert into int in maria db
SQL
0 vote187 views1 answer
Initcap in mysql
SQL
3 votes184 views2 answers
Mysql config user password
SQL
0 vote228 views1 answer
Mysql select row with min date
SQL
5 votes172 views1 answer
Postgres integer to serial
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL