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 vote126 views1 answer
Get time component of datetime sql
SQL
0 vote116 views1 answer
Group_concat only returns one row
SQL
1 vote107 views1 answer
Real world example of nosql
SQL
0 vote109 views1 answer
Stuff in sql server
SQL
1 vote125 views1 answer
Mysql sort by date column
SQL
7 votes130 views1 answer
Oracle reset sequence
SQL
0 vote125 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote157 views1 answer
Sql count matching group by
SQL
3 votes126 views3 answers
Stop mysql ubuntu
SQL
9 votes268 views2 answers
Current date in postgresql minus 1 day
SQL