用需要合併記錄集的朋友是個參考DELETE FROM Tables WHERE ID NOT IN (SELECT Min(ID) FROM Tables GROUP BY Name) Min的話保留最小的或者保留最大那就改成Max即可