SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH CTE AS
(
SELECT '01-01-2024' CREATE_DATE,'10' ROWID,'1' SUBROWID,'222-223-1600' PHN_NR,'MOB' PHN_TYP UNION ALL
SELECT '01-02-2024','10','1','222-223-1600','BSNS' UNION ALL
SELECT '01-03-2024','10','1','222-223-1600','MOB' UNION ALL
SELECT '01-04-2024','10','1','222-223-1600','MOB' UNION ALL
SELECT '01-05-2024','10','1','222-223-1600','MOB' UNION ALL
SELECT '01-06-2024','10','1','222-223-1600','MOB' UNION ALL
SELECT '01-07-2024','10','1','222-223-1600','MOB' UNION ALL
SELECT '01-01-2024','11','2','111-444-5555','BSNS' UNION ALL
SELECT '01-02-2024','11','2','111-444-5555','BSNS' UNION ALL
SELECT '01-03-2024','11','2','111-444-5555','MOB' UNION ALL
SELECT '01-04-2024','11','2','111-444-5555','BSNS'
),
CTE2 AS
(
SELECT *,
       flag = case when SUBROWID = LAG(SUBROWID) OVER (PARTITION BY ROWID ORDER BY CREATE_DATE) 
                   and  PHN_NR   = LAG(PHN_NR) OVER (PARTITION BY ROWID ORDER BY CREATE_DATE) 
                   and  PHN_TYP  = LAG(PHN_TYP) OVER (PARTITION BY ROWID ORDER BY CREATE_DATE) 
                   then 1 
                   else 0 
                   end
FROM   CTE
)
SELECT *
FROM   CTE2
WHERE  flag = 0
ORDER BY ROWID, CREATE_DATE

CREATE_DATE	ROWID	SUBROWID	PHN_NR	PHN_TYP
01-01-2024	10	1	222-223-1600	MOB
01-02-2024	10	1	222-223-1600	BSNS
01-03-2024	10	1	222-223-1600	MOB
01-01-2024	11	2	111-444-5555	BSNS
01-03-2024	11	2	111-444-5555	MOB
01-04-2024	11	2	111-444-5555	BSNS