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

16 votes154 views4 answers
Find duplicates mysql
SQL
3 votes118 views2 answers
To_char sql
SQL
0 vote178 views1 answer
Sql server system messeges
SQL
1 vote141 views1 answer
Snowflake rename column name
SQL
0 vote140 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
2 votes140 views1 answer
How to show the whole table in sql
SQL
0 vote126 views1 answer
Create table Statement Syntax in SQL Server
SQL
1 vote117 views2 answers
Mysql type conversion
SQL
0 vote148 views1 answer
"Hello User Name"
SQL
0 vote125 views1 answer
Why we have to set the password for my sql server
SQL