Input
- employee_table, as in NTree Example 1: Find Employee Reports
SQL Call
This call finds the management chain of employee 500 by traversing the tree of employees from employee 500 upward.
SELECT * FROM NTree@coprocessor ( ON employee_table PARTITION BY 1 USING Root_Node (mgr_id IS NULL) Node_ID (emp_id) Parent_ID (mgr_id) Starts_With (emp_id=500) Mode ('up') Output ('end') Result (PATH(emp_name) AS path) ) AS dt ORDER BY 1;
Output
The output table shows that employee 500, Fred, reports to Kim, who reports to Pat, who reports to Don.
id | path |
---|---|
100 | Fred->Kim->Pat->Don |