Al GALI fem la següent consulta:
SELECT y.HAV_DISTRIT, y.hav_seccion, y.hav_nhojpad, count(*)
FROM (SELECT distinct a.HAV_DISTRIT,a.hav_seccion,a.hav_nhojpad,a.hav_ndomici FROM habvar a) AS y
GROUP BY y.HAV_DISTRIT, y.hav_seccion, y.hav_nhojpad
HAVING count(*)>1;