SQL查找重复项目
标签：
SQL查找重复项目
SELECT t1.*
2 FROM t1,
3 (SELECT name,ADD
4 FROM t1
5 GROUP BY name,ADD HAVING COUNT(1) > 1) AS t2
6 WHERE t1.name = t2.name
7 AND t1.ADD = t2.ADD;