Highlighted
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-25-2019
02:54 AM
12-25-2019
02:54 AM
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
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
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.