Relative Content

Tag Archive for common-table-expressionupdates

update column value with cte

Can someone please help. I am looking to update column value.
For each item_id and based on agreem_id A, I wanted to update term-0,12,24,36. When Agreem_id changed to B it should update only 0,12,24.