By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| Pat | c1 | c2 | c3 | c4 | c5 |
|---|---|---|---|---|---|
| Pat1 | U212 | Y973 | Y982 | null | null |
| Pat2 | M653 | null | null | null | null |
| Pat3 | U212 | Y973 | Y983 | Z924 | Z926 |
Warning: Null value is eliminated by an aggregate or other SET operation.