Id CategoryId Category Type Description Mapped
61068 463 Cat1 Maximum Benefit Benefit : 100rs 1,2,3
61068 464 Cat2 Deductible Deductible : 50rs 4,5
61068 464 Cat2 Maximum Benefit Benefit : 100rs 1,2,3
61068 465 Cat3 Maximum Benefit Benefit : 100rs 6,7
61068 464 Cat2 Maximum Benefit Benefit : 100rs 1,2,3
I have the above table and i have to update the same table with new modification
i need to write the query to get the below reult.
Id CategoryId Category Type Description Mapped
61068 463 Cat1 Maximum Benefit Benefit : 100rs 1,2,3
61068 464 Cat2 Deductible Deductible : 50rs 4,5
61068 464 Cat2 Same as Cat1 Benefit : 100rs 1,2,3
61068 465 Cat3 Maximum Benefit Benefit : 100rs 6,7
61068 464 Cat2 Same as Cat1 Benefit : 100rs 1,2,3
need your help to update the same table to get the record updated.