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

1 vote383 views3 answers
Rename table snowflake
SQL
0 vote344 views1 answer
IS THEre any difference between using default and := in plsql
SQL
1 vote359 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote379 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
4 votes357 views1 answer
Create db table
SQL
1 vote355 views1 answer
How to update date add hours in postgresql
SQL
0 vote359 views1 answer
Db format in quotation
SQL
0 vote379 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote358 views1 answer
Trigger stock phpmyadmin output message
SQL
36 votes422 views6 answers
Change column data type sql
SQL