By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | loc1 | loc2 | zip_code |
---|---|---|---|
10 | 1 | null | 12345 |
10 | null | 1 | null |
11 | 1 | null | null |
11 | null | 1 | 43210 |
12 | 1 | null | 54321 |
12 | null | 1 | 87654 |
13 | 1 | null | null |
13 | null | 1 | null |
14 | 1 | null | 65432 |
15 | 1 | null | null |
16 | null | 1 | 76767 |
17 | null | 1 | null |
id | loc1 | loc2 | zip_code |
---|---|---|---|
10 | 1 | null | 12345 |
11 | null | 1 | 43210 |
12 | 1 | null | 54321 |
13 | 1 | null | null |
14 | 1 | null | 65432 |
15 | 1 | null | null |
16 | null | 1 | 76767 |
17 | null | 1 | null |
id | loc1 | loc2 | zip_code |
---|---|---|---|
10 | 1 | null | 12345 |
11 | null | 1 | 43210 |
12 | 1 | null | 54321 |
13 | 1 | null | null |
14 | 1 | null | 65432 |
15 | 1 | null | null |
16 | null | 1 | 76767 |
17 | null | 1 | null |