您可以尝试类似
SELECT PersonName,
Address
FROM (
SELECT *,
(SELECT COUNT(1) FROM addresses WHERE Address = a.Address AND PersonName < a.PersonName) CountLess
FROM addresses a
) sub
WHERE sub.CountLess <= 2