Help : Identifying the Multi row concept

[Srikanth_Baldwa]

Hello Team

can you please help me out for writing the query for a table having two similar rows have to update in other column of same row for first row as A & second row as B

Output for refrence

Name	City	Country	Flag
Srikanth	Hyderabad	India	A
Srikanth	Hyderabad	India	B
Rahul	Bangalore	India	A
Rajeev	Bangalore	India	A
Sunil	Hyderabad	India	A
Sunil	Hyderabad	India	B

Also if i want to write with one particular column for example from above table it will check the name if name as two similar then it should update A and B

Thanks

Srikanth B