Deleting duplicates keeping the minimum ID
duplicates, oracle11g, sql
Solution
DELETE FROM persons WHERE id NOT IN (SELECT MIN(id) FROM persons GROUP BY name)
Problem
I have a persons table with duplicate person inserted with different id. I want to delete the person with duplicate names keeping only the person with the minimum ID. for e.G The record for Absalon with ID 18398 should remain and all the other duplicates are deleted.