By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | value |
|---|---|
| 1 | 123 |
| 2 | null |
| 3 | null |
| 4 | 456 |
| 5 | null |
| 6 | null |
| 7 | 789 |
| 8 | null |
| 9 | null |
| id | value | Z | N01 |
|---|---|---|---|
| 1 | 123 | 1 | 123 |
| 2 | null | 1 | 123 |
| 3 | null | 1 | 123 |
| 4 | 456 | 2 | 456 |
| 5 | null | 2 | 456 |
| 6 | null | 2 | 456 |
| 7 | 789 | 3 | 789 |
| 8 | null | 3 | 789 |
| 9 | null | 3 | 789 |