How we can update only two records out of 3 using Execute Non Query update

Hi All,

I need to update the data in the table I’ve already entered in SQL database. The column name in the table called Status .
I need to update two records out of 3 in sql database and all 3 has same value in it except ID and ProcessTime.
“UPDATE tablename Set Status = @Status Where OrderNo = @Pos” --This query is updating all records with Status “Duplicate” which is not correct.
It should only change 2 records status as Duplicate.

Please help.

Hello @Poonam_Yadav ,

Is there any condition like the last 2 values need to update or the first 2 values? Based on what we can confirm the value to modify?

No condition are there.

Thanks Everyone, Issue got resolved now.