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 vote236 views1 answer
Sql get year from datetime field
SQL
0 vote179 views2 answers
Denormalization in sql
SQL
8 votes223 views1 answer
Insert a select statement into a table
SQL
0 vote254 views1 answer
Prisma transaction
SQL
0 vote233 views1 answer
Mariadb datetime change to microseconds
SQL
1 vote244 views1 answer
Postgresql export output table as a csv
SQL
5 votes229 views1 answer
Oracle nls instance
SQL
1 vote219 views1 answer
Input in mysql
SQL
0 vote232 views1 answer
Java check if something is in mysql table
SQL
0 vote214 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL