By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| ID | No | NameA1 | LetterA1 | AnswerA1 | CMTA1 | NameA2 | LetterA2 | AnswerA2 | CMTA2 | NameA3 | LetterA3 | AnswerA3 | CMTA3 | NameA4 | LetterA4 | AnswerA4 | CMTA4 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 | 103 | A1 | A | Low | Abc | A2 | B | High | Abc | A3 | A | Medium | Cde | A4 | C | Low | Hhj |
Warning: Null value is eliminated by an aggregate or other SET operation.