Hi All,
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
Abhas 1
Mike 2
John 3
David 4
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.