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
;
|
转载于:https://www.cnblogs.com/yzpopulation/p/4916892.html