By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EMP | EMPNAME | SUBBOSS | SUBBOSSNAME | BOSS | BOSSNAME |
|---|---|---|---|---|---|
| 100 | Sara | 110 | Ross | 111 | Mon |
| 101 | Ben | 111 | Mon | null | null |
| 102 | Alex | 110 | Ross | 111 | Mon |
| 110 | Ross | 111 | Mon | null | null |
| 111 | Mon | null | null | null | null |