cancel
Showing results for 
Search instead for 
Did you mean: 

Help : Identifying the Multi row concept

Level 2 Adventurer

Help : Identifying the Multi row concept

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

NameCityCountryFlag
SrikanthHyderabadIndiaA
SrikanthHyderabadIndiaB
RahulBangaloreIndiaA
RajeevBangaloreIndiaA
SunilHyderabadIndiaA
SunilHyderabadIndiaB

 

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