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 vote244 views1 answer
Mysql terminal run sql file
SQL
6 votes235 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote245 views1 answer
Set root password mysql xampp
SQL
10 votes261 views4 answers
SELECT FROM WHERE
SQL
0 vote237 views1 answer
Mysql filter based on datediff
SQL
0 vote242 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote238 views1 answer
Best sql course
SQL
-1 vote238 views2 answers
First letter capital in mysql query
SQL
0 vote235 views1 answer
Inner join distinct
SQL
13 votes246 views2 answers
Get tables in database sql
SQL