By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| rowId | name | Column1 |
|---|---|---|
| 1 | Bob | Male |
| 2 | Sally | |Gender - Female| |Age - 30| |
| 3 | John | Male |
| 4 | Thomas | Male |
| 5 | Lewis | |Gender - Male| |Age - 20| |
Warning: Null value is eliminated by an aggregate or other SET operation.