Remove new duplicates from any sql table

DELETE FROM yourTable 
WHERE id NOT IN (SELECT MIN(id) 
                 FROM yourTable 
                 GROUP BY anotherColumn)

If you want to remove older rows, use the following:

DELETE FROM yourTable 
WHERE id NOT IN (SELECT MAX(id) 
                 FROM yourTable 
                 GROUP BY anotherColumn)

Posted

July 28, 2021

Harshvardhan Malpani

Tags:

Comments