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)))
posted on 2016-03-29 14:17
聶文龍 閱讀(120)
評(píng)論(0) 編輯 收藏 引用