update only one row from 2 exactly similar rows

there are 2 rows, with no PK.. both are exactly same.. I need to make one different with an update.. but whatever condition i give it is going to update both.. how can i update just one through tsql code?
LVL 5
25112Asked:
Who is Participating?
 
f_o_o_k_yConnect With a Mentor Commented:
More complex example:


result:


Best Regards
Fooky
0
 
f_o_o_k_yCommented:
UPDATE TOP 1 table_name
SET col=val
WHERE <condition>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.