Delete duplicate values in the same field in SQL

Mesh: Zdjz_dis The Name field has a duplicate value, delete the duplicate value of delete *from zdjz_diswhere name in  (the select name from Zdjz_dis GROUP BY NAME has count (name) >1); The above practice removes all the same values, including the one you want, and deletes delete *from zdjz_diswhere ID in  (select min) as long as you repeat ID) from Zdjz_dis GROUP by NAME has count (NAME) >1); 1 There are no duplicates of a value  2 if any, select the one with the smallest ID to combine the delete *from Zdjz_diswhere Name in  (select name from Zdjz_dis group by name has count (name) >1) and ID not in (select min (ID) from Zdjz_dis GROUP BY NAME has count (name) >1);

　　

Delete duplicate values in the same field in SQL