I want to find Hierarchy of managers for specific employee. For example if I run query for David Then Output like below
MANAGER Hierarchy Level
I am having two tables. Employee where all employee details are stored. I need to fetch Employee Name as MANAGER from this table. And ManagerID from Supervisor Table.