By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| EMP_ID | EMP_NAME | MANAGER_ID | MANAGER_NAME |
|---|---|---|---|
| 105 | VP | 0 | null |
| 104 | Director | 105 | VP |
| 103 | Sr. Manager | 104 | VP |
| 102 | Manager | 103 | VP |
| 101 | Team Lead | 102 | VP |
| 100 | Employee | 101 | VP |