untested...
;with cte as
(
SELECT House_acc
FROM yourtable
GROUP BY House_acc
HAVING (COUNT(DISTINCT repcode) > 1)
)
SELECT A.House_acc ,
A.AccountId ,
A.repcode
FROM
cte INNER JOIN yourtable AS A ON cte.House_acc = A.House_acc;
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day