问题描述
编写程序以找到员工编号"104"的直属经理和所有上级.
EmployeeId --- ManagerId ---名称
101---CEO
102-101-GM
103-102-经理
104-103-软件工程师
105-103-软件工程师
从上面提到的数据结构中，编写一个程序来查找直属经理和员工104的所有上级.
上面提到的数据结构包含employeeId，ManagerId，designation
Write a program to find the immediate Manager and all the superiors for employee number ‘104’.
EmployeeId ---ManagerId ---Designation
101 -- -- -- CEO
102 -- 101 -- GM
103 -- 102 -- MANAGER
104 -- 103 -- SOFTWARE ENGINEER
105 -- 103 -- SOFTWARE ENGINEER
From the above mentioned data structure, Write a program to find the immediate Manager and all the superiors of employee 104.
The above mentioned data structure holds employeeId, ManagerId, designation
推荐答案
try the below link
[ ^ ] []
http://noprobs.wordpress.com/2010/07/27/hierarchical-list-of-managers-for-a-given-employee-using-common-table-expression/[^][]
这篇关于编写程序以找到员工编号"104"的直属经理和所有上级.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！