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 |