By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| colA | colB |
|---|---|
| 1 | 1 |
| 1 | 2 |
| null | 1 |
| 1 | null |
| null | null |
| colA | colB | distinct_from | distinct_from2 | distinct_from2b | distinct_from3 | not_distinct_from | not_distinct_from2 | not_distinct_from3 |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| 1 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| null | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| 1 | null | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| null | null | 0 | 0 | 0 | 0 | 1 | 1 | 1 |