code:
Должно получиться наподобие следующего:

DECLARE @t TABLE
(
[Name] varchar(10) NOT NULL,
[Phone] char(5) NOT NULL,
[Street_No] int NOT NULL
)

INSERT @t ([Name], [Phone], [Street_No]) VALUES ('Olia', '25466', 45)
INSERT @t ([Name], [Phone], [Street_No]) VALUES ('Katia', '12548', 14)
INSERT @t ([Name], [Phone], [Street_No]) VALUES ('Katia', '25644', 10)


SELECT t1.*
FROM
(
SELECT t.[Name], t.[Phone], MAX(t1.[Street_No]) AS [Street_No]
FROM
(
SELECT t.[Name], MAX(t.[Phone]) AS [Phone]
FROM
@t t
GROUP BY t.[Name]
) t
INNER JOIN @t t1
ON t.[Name] = t1.[Name] AND t.[Phone] = t1.[Phone]
GROUP BY t.[Name], t.[Phone]
) x
INNER JOIN
(
SELECT t1.[Name], t1.[Phone] AS [Phone1], t2.[Phone] AS [Phone2], t1.[Street_No] AS [Street_No1], t2.[Street_No] AS [Street_No2]
FROM
@t t1
LEFT OUTER JOIN @t t2
ON t1.[Name] = t2.[Name] AND (t1.[Phone] <> t2.[Phone] OR t1.[Street_No] <> t2.[Street_No])
) t1
ON t1.[Name] = x.[Name] AND t1.[Phone1] = x.[Phone] AND t1.[Street_No1] = x.[Street_No]