top of page

Update Second Row if two rows has same values


Here i want to Update the Second repeated digit Like (3 as 6) without any Unique column.

As per above given attach.

Query :

create table #temp(Item int)

insert into #temp values(3)

insert into #temp values(5)

insert into #temp values(Null)

insert into #temp values(8)

insert into #temp values(Null)

insert into #temp values(3)

select * from #temp

WITH MyTable AS

(

SELECT Item,

ROW_NUMBER() OVER ( ORDER BY Item ) AS 'RowNumber'

FROM #temp

)

update MyTable set item=6 where RowNumber=3

--SELECT RowNumber,item

--FROM MyTable

--WHERE Item = 3

select * from #temp


RECENT POST
bottom of page