By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EMPID | MGRID | LVL1 | LVL2 | LVL3 |
|---|---|---|---|---|
| A | B | D | C | B |
| B | C | D | C | null |
| C | D | D | null | null |
| I | J | D | J | null |
| J | D | D | null | null |
| K | L | D | O | L |
| L | O | D | O | null |
| O | D | D | null | null |
| EMPID | MGRID | LVL1 | LVL2 | LVL3 |
|---|---|---|---|---|
| A | B | D | C | B |
| B | C | D | C | null |
| C | D | D | null | null |
| I | J | D | J | null |
| J | D | D | null | null |
| K | L | D | O | L |
| L | O | D | O | null |
| O | D | D | null | null |