This call finds the employees who report to employee 100 (either directly or indirectly) by traversing the tree of employees from employee 100 downward.
SELECT * FROM ntree ( ON employee_table PARTITION BY 1 Root_Node (mgr_id IS NULL) Node_ID (emp_id) Parent_ID (mgr_id) Starts_With (emp_id=100) Mode ('down') Output ('end') Result (PATH(emp_name) AS path) ) ORDER BY 1;