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

8 votes197 views1 answer
Sql remove leading spaces
SQL
18 votes230 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote210 views1 answer
Alter rename command in mysql
SQL
0 vote210 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote212 views2 answers
Get item by composite primary key mysql
SQL
15 votes178 views4 answers
T-sql drop function if exists
SQL
0 vote194 views4 answers
Mysql on kubernetes
SQL
4 votes193 views2 answers
Sql vs mysql
SQL
0 vote181 views2 answers
Mysql regexp match word
SQL
0 vote204 views1 answer
Rename constraint postgresql
SQL