By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
ID | Color1 | Color2 | Color3 |
---|---|---|---|
1 | Red | NA | Blue |
2 | NA | NA | Blue |
3 | NA | NA | Blue |
4 | NA | Green | Blue |
4 rows affected
ID | Color1 | Color2 | Color3 |
---|---|---|---|
1 | Red | NA | Blue |
2 | NA | NA | Blue |
3 | NA | NA | Blue |
4 | NA | Green | Blue |