SQL Server 2019

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

Create Table your_table(ID INT, PRE VARCHAR(50), IDENTIFIER BIGINT);

Insert Into your_table Values
(123456789,'ABC',1176109555),
(123456789,'ABC',1430842555),
(123456789,'ABC',1572290555),
(123456789,'ABC',1651845555),
(123456789,'ABC',2099393555),
(111111111,'ABC',5555393555);
6 rows affected

Select * From 
(
   Select IDENTIFIER,
   Max(IDENTIFIER) Over (Partition By ID) as CORRECTED_IDENTIFIER
   From your_table
) D
Where D.IDENTIFIER<>CORRECTED_IDENTIFIER


IDENTIFIER
CORRECTED_IDENTIFIER


1176109555
2099393555

1430842555
2099393555

1572290555
2099393555

1651845555
2099393555


With CTE As
(
   Select * From 
  (
    Select IDENTIFIER,
    Max(IDENTIFIER) Over (Partition By ID) as CORRECTED_IDENTIFIER
    From your_table
  ) D
  Where D.IDENTIFIER<>CORRECTED_IDENTIFIER
)

Update CTE Set IDENTIFIER = CORRECTED_IDENTIFIER;
4 rows affected

Select * From your_table;


ID
PRE
IDENTIFIER


123456789
ABC
2099393555

123456789
ABC
2099393555

123456789
ABC
2099393555

123456789
ABC
2099393555

123456789
ABC
2099393555

111111111
ABC
5555393555

IDENTIFIER	CORRECTED_IDENTIFIER
1176109555	2099393555
1430842555	2099393555
1572290555	2099393555
1651845555	2099393555

ID	PRE	IDENTIFIER
123456789	ABC	2099393555
123456789	ABC	2099393555
123456789	ABC	2099393555
123456789	ABC	2099393555
123456789	ABC	2099393555
111111111	ABC	5555393555