22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT a.*
FROM jcdz a
INNER JOIN
(
SELECT street,xzqhdm
FROM jcdz
GROUP BY street,xzqhdm
HAVING COUNT(DISTINCT zip)>1
) b
ON a.street=b.street AND a.xzqhdm=b.xzqhdm
select * from jcdz a join jcdz b on a.street=b.street and...