By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| employee_id | name | manager_id | department | lob |
|---|---|---|---|---|
| 12 | a | null | IT | BFI |
| 3 | b | 12 | sales | null |
| 4 | c | 3 | null | Banking |
| 6 | d | 12 | null | null |
| 7 | e | 4 | null | null |
| 10 | f | 7 | null | null |
| employee_id | name | manager_id | department | lob |
|---|---|---|---|---|
| 12 | a | null | IT | BFI |
| 3 | b | 12 | sales | BFI |
| 6 | d | 12 | IT | BFI |
| 4 | c | 3 | sales | Banking |
| 7 | e | 4 | sales | Banking |
| 10 | f | 7 | sales | Banking |