By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
CurrCode | Lvl0Code | Lvl0Name | Lvl1Code | Lvl1Name | Lvl2Code | Lvl2Name | Lvl3Code | Lvl3Name |
---|---|---|---|---|---|---|---|---|
AA0001 | AA0001 | CEO | na | na | na | na | na | na |
AA0001 | AA0001 | CEO | AA0002 | CFO | na | na | na | na |
AA0001 | AA0001 | CEO | AA0002 | CFO | AA0003 | CIO | na | na |
AA0001 | AA0001 | CEO | AA0002 | CFO | AA0004 | SnrMgr | na | na |
AA0001 | AA0001 | CEO | AA0002 | CFO | AA0004 | SnrMgr | AA0005 | JnrMgr |
AA0001 | AA0001 | CEO | AA0002 | CFO | AA0003 | CIO | AA0006 | ItMgr |