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; |
原文：http://www.cnblogs.com/yzpopulation/p/4919065.html