查找某些记录中重复的记录

SELECT Account,COUNT(Account) AS RowNum FROM BBS_User_OtherInfo WHERE Account IS NOT NULL GROUP BY Account HAVING COUNT(Account) > 1
posted @ 2005-03-18 16:57  9527的晃悠人生  阅读(490)  评论(0)  编辑  收藏  举报