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 vote170 views1 answer
How to set sql_mode for a query in CI model
SQL
4 votes163 views2 answers
Truncate oracle
SQL
0 vote224 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote164 views1 answer
Mysql group rows with same value
SQL
5 votes230 views1 answer
How to get all table names in sql query
SQL
0 vote155 views1 answer
Count the table indatabase
SQL
0 vote209 views1 answer
Sql select rows with different values in one column
SQL
0 vote172 views1 answer
How change the field place in mysql
SQL
3 votes172 views2 answers
Monthname sql
SQL
1 vote170 views1 answer
Postgresql convert text to float
SQL