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

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

WDYDXF

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

阅读量1.9k

点赞数

分类专栏：备份文章 SQLSever

本文链接：https://blog.csdn.net/wdydxf/article/details/43737505

版权

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

44 篇文章 0 订阅

订阅专栏

SQLSever

16 篇文章 0 订阅

订阅专栏

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))