SQL查找重复项目

1
2
3
4
5
6
7
SELECT t1.*
FROM t1,
  (SELECT name,ADD
   FROM t1
   GROUP BY name,ADD HAVING COUNT(1) > 1) AS t2
WHERE t1.name = t2.name
  AND t1.ADD = t2.ADD;






posted @ 2015-10-28 12:01  月渊  阅读(224)  评论(0)    收藏  举报