By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
ANCESTOR | DEPT_ID | PATH |
---|---|---|
5500 | 5510 | >5500>5510 |
5500 | 5511 | >5500>5510>5511 |
5500 | 5512 | >5500>5510>5512 |
5500 | 5513 | >5500>5510>5513 |
5500 | 5514 | >5500>5510>5514 |
5500 | 5515 | >5500>5510>5515 |
5500 | 5520 | >5500>5520 |
5500 | 5521 | >5500>5520>5521 |
5500 | 5522 | >5500>5520>5522 |
5500 | 5530 | >5500>5530 |
5500 | 5531 | >5500>5530>5531 |
5500 | 5532 | >5500>5530>5532 |
5500 | 5540 | >5500>5540 |
5500 | 5533 | >5500>5540>5533 |
5500 | 5534 | >5500>5540>5533>5534 |
5500 | 5590 | >5500>5590 |
5500 | 5591 | >5500>5590>5591 |
5510 | 5511 | >5510>5511 |
5510 | 5512 | >5510>5512 |
5510 | 5513 | >5510>5513 |
5510 | 5514 | >5510>5514 |
5510 | 5515 | >5510>5515 |
5520 | 5521 | >5520>5521 |
5520 | 5522 | >5520>5522 |
5530 | 5531 | >5530>5531 |
5530 | 5532 | >5530>5532 |
5533 | 5534 | >5533>5534 |
5540 | 5533 | >5540>5533 |
5540 | 5534 | >5540>5533>5534 |
5590 | 5591 | >5590>5591 |