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

15 votes137 views4 answers
Create table if not exists sql
SQL
3 votes157 views5 answers
Duplicate table sql
SQL
2 votes136 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote125 views2 answers
Mysql two column combination unique
SQL
28 votes179 views6 answers
Foreign key
SQL
0 vote126 views1 answer
View acl table oracle
SQL
3 votes125 views1 answer
What is having clause
SQL
0 vote131 views1 answer
Postegresql update to null
SQL
0 vote258 views1 answer
Oracle convert int to date
SQL
0 vote127 views1 answer
Mysql return column names when table is empty
SQL