delete ta from table d where ID <> (select top 1 [ID] from ta c where c.[Name]=d.[Name] order by ID desc)
删除重复记录,保留最新插入记录
最新推荐文章于 2023-03-13 18:59:40 发布
delete ta from table d where ID <> (select top 1 [ID] from ta c where c.[Name]=d.[Name] order by ID desc)