By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
EId | HomeNum | MobileNum | WorkNum | WorkNumExt | MainPhType |
---|---|---|---|---|---|
1 | 111111111 | 222222222 | 333333333 | null | Mobile |
2 | null | 454545454 | 444444444 | 567 | Work |
3 | 777777777 | 888888888 | null | null | Mobile |
4 | null | null | 101010101 | 111 | Work |
5 | null | null | 456456456 | null | Work |
6 | null | null | null | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.