change value在java,Change value of duplicated rows

You can try the following query

create table #tblSimilarValues(id int, ipaddress varchar(20))

insert into #tblSimilarValues values (4, '192.168.0.22'),

(4, '192.168.0.22'),(4, '192.168.0.22')

Use Below query if you want to change all rows

with oldData as (

select *,

count(*) over (partition by id, ipaddress) as cnt

from #tblSimilarValues

)

update oldData

set ipaddress = '192.168.0.22_1'

where cnt > 1;

select * from #tblSimilarValues

Use Below query if you want to skip firs row

;with oldData as (

select *,

ROW_NUMBER () over (partition by id, ipaddress order by id, ipaddress) as cnt

from #tblSimilarValues

)

update oldData

set ipaddress = '192.168.0.22_2'

where cnt > 1;

select * from #tblSimilarValues

drop table #tblSimilarValues

You can find the live demo live demo here