摘要: 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 @
2016-03-29 14:17 聶文龍 閱讀(118) |
評論 (0) |
編輯 收藏