sql server 删除重复数据保留id大的

最新推荐文章于 2022-08-16 15:34:02 发布

原创最新推荐文章于 2022-08-16 15:34:02 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

备份文章同时被 2 个专栏收录

44 篇文章

订阅专栏

SQLSever

16 篇文章

订阅专栏

本文介绍了一种批量删除网页翻译中重复翻译项的方法，通过SQL语句筛选并删除了重复的Translation表中的记录，确保了翻译内容的独特性。

DELETE FROM [Translation] where keyid in
(SELECT T.KeyID FROM [Translation] as T WHERE T.PageID=6088 And T.KeyID<=61866 And
T.TranslationKey IN (SELECT T1.TranslationKey FROM [Translation] as T1 GROUP BY TranslationKey HAVING COUNT(T1.TranslationKey)>1)

AND T.KeyID NOT IN (SELECT MAX(T2.KeyID) FROM [Translation] as T2 GROUP BY T2.TranslationKey HAVING COUNT(T2.TranslationKey)>1))

DELETE  FROM [Translation]  where keyid in  
(SELECT T.KeyID FROM [Translation] as T WHERE T.PageID=6088 And T.KeyID<=61866 And
T.TranslationKey IN (SELECT T1.TranslationKey FROM [Translation] as T1 GROUP BY TranslationKey HAVING COUNT(T1.TranslationKey)>1) 
AND T.KeyID NOT IN (SELECT MAX(T2.KeyID) FROM [Translation] as T2 GROUP BY T2.TranslationKey HAVING COUNT(T2.TranslationKey)>1))