|
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;
|
|
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;
|