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 vote331 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
17 votes337 views2 answers
Mysql date to string
SQL
2 votes332 views6 answers
In operator in sql
SQL
0 vote326 views1 answer
Mysql filter based on datediff
SQL
5 votes343 views1 answer
Oracle sysdate - 1 month
SQL
1 vote281 views1 answer
Ms sql how to see active job current run time
SQL
0 vote346 views1 answer
Oracle select partition
SQL
0 vote291 views1 answer
Print sum of values sql
SQL
0 vote350 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
6 votes348 views2 answers
Mysql 1 day ago
SQL