摘要:SQL 查找重複資料
SELECT * FROM TableName
WHERE createDateTime >= '2002-12-17 00:00:00' AND objId IN
(SELECT objId FROM TableName
GROUP BY objId
HAVING(count( *))>1)
ORDER BY objId
參考連結：http://hi.baidu.com/zg110/blog/item/d89d9452b426350e0cf3e30b.html
2009-12-19