IT博客汇 | 去重复

去重复

聂文龙发表于 2016-03-29 06:17:00

DELETE FROM UserInfo

WHERE (UserName IN

(SELECT UserName

FROM Baidu_TieBa..UserInfo

GROUP BY UserName

HAVING COUNT(UserName) > 1)) AND (id NOT IN

(SELECT MIN(id)

FROM UserInfo

GROUP BY UserName

HAVING (COUNT(UserName) > 1)))

聂文龙 2016-03-29 14:17 发表评论