SELECT * FROM ntree (
ON emp_table_by_dept PARTITION department
Root_Node (mgr_id = 'none')
Parent_ID (mgr_id)
Node_ID (id)
Starts_With ('root')
Mode ('down')
Output ('all')
Result (PATH(name) AS path, PATH(id) AS path2)
) ORDER BY path, path2;