Hi,
COl1 COl2
---- ----
A123 IPX
A123 IPY
A123 IPZ
A123 NULL
B123 IPY
B123 IPZ
B123 NULL
C123 IPZ
C123 NULL
if col2 has IPX, Would like to update all rows with IPX
if col2 has IPY, would like to update all rows with IPY -- A123 IPY is alrdy updated with IPX from the above condition
if col2 has IPZ, would like to update all rows with IPZ -- B123 IPZ is alrdy updated with IPY from the second condition
Best way to write the update statement by keeping all in one single statement, instead of writing three separate update statements.
Please advise.
Thanks