We can have simple update statement for such case with the proper clauses. 2nd option is to use Cursor. When I replied with the update statement to their panel then the interviewer asked me for other better option then I told her about cursor. Still negative feedback. 2nd time - same technical panel asked the same question, I started with the cursor. Still same feedback. Although, I have provided approximately - 90% of the correct answer. Still, they have negative feedback.