By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
id | blahblah | userid | value |
---|---|---|---|
1 | blah-1 | null | null |
2 | null | user-1 | null |
3 | null | null | value-1 |
4 | blah-2 | null | null |
5 | null | user-2 | null |
6 | null | null | value-3 |
rowno | blahblah | userid | datavalue |
---|---|---|---|
1 | blah-1 | user-1 | value-1 |
2 | blah-2 | user-2 | value-3 |
Warning: Null value is eliminated by an aggregate or other SET operation.