For friends who need to merge record sets, this is a reference DELETE FROM Tables WHERE ID NOT IN (SELECT Min(ID) FROM Tables GROUP BY Name) If Min, keep the smallest one Or keep the maximum and change it to Max
