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

3 votes162 views1 answer
Force using index plsql
SQL
0 vote140 views1 answer
Order by ip address sql
SQL
37 votes194 views6 answers
Mysql update
SQL
0 vote177 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
4 votes147 views1 answer
To date oracle with time
SQL
0 vote147 views1 answer
How to find columns with null values in sql
SQL
0 vote153 views1 answer
Intellij mysql set timezone
SQL
3 votes136 views1 answer
Start mysql server linux terminal
SQL
3 votes157 views4 answers
Truncate syntax in sql
SQL
0 vote139 views1 answer
Mysql isshow
SQL