Help : Identifying the Multi row concept

Highlighted
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

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks