SQL里如何删除重复的字符串

发布网友发布时间：2022-05-05 10:30

共2个回答

热心网友时间：2022-05-05 12:00

delete from TABLE_name t1 where t1.rowid > (select min(rowid) from TABLE_name t2 where t1.name = t2.name group by name having count(name) > 1)
--还可以新建一张中间表，将distinct记录选出来
select distinct * into temptable from TABLE_name
delete from TABLE_name
insert into TABLE_name select * from temptable

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com