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 vote356 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
20 votes363 views6 answers
Mysql reset auto increment
SQL
1 vote331 views3 answers
Default password of mysql
SQL
0 vote342 views1 answer
Sql beginning of previous month
SQL
2 votes370 views2 answers
Enable foreign key checks postgres
SQL
0 vote340 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
11 votes392 views2 answers
Mysql disable safe mode
SQL
0 vote382 views1 answer
Csv to sqlite python
SQL
4 votes343 views1 answer
Oracle show errors compilation
SQL
2 votes367 views1 answer
How to get non distinct values in sql
SQL