By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| id | technology | time | value | technology 2 |
|---|---|---|---|---|
| 1 | technology 1 | 123 | 2 | 3 |
| 3 | technology 3 | 123 | 0.5 | 3 |
| 4 | technology 1 | 124 | 3 | 1,2 |
| 6 | technology 3 | 124 | 8 | 1,2 |
Warning: Null value is eliminated by an aggregate or other SET operation.