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
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
You can add one additional column to this table which will have the primary key and using it in update statement you can write the update query.
as mentioned i have added the primary key but unable to write the syntax can you please help me out for writing the syntax for it.
For syntax, you can refer to the below PostgreSQL documentation link.