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 vote287 views1 answer
How to alter length character varying postgres
SQL
0 vote276 views1 answer
Oracle service name view
SQL
0 vote258 views2 answers
Avg() sql
SQL
14 votes288 views3 answers
Delete all records from table except sql
SQL
4 votes294 views2 answers
Dbms output
SQL
0 vote274 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote278 views2 answers
Enter into postgresql database,create user and grant Access
SQL
11 votes286 views1 answer
Get ddl materialized view oracle
SQL
0 vote277 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote273 views1 answer
Get records in sql according to month name and count
SQL