您的当前位置:首页 >时尚 >如何用Oracle实现组织结构中的汇总统计 正文

如何用Oracle实现组织结构中的汇总统计

时间:2025-11-05 04:58:31 来源:网络整理编辑:时尚

核心提示

复制Employee Manager Pathlen Path --------------- --------------- ---------

复制

Employee        Manager            Pathlen Path --------------- --------------- ---------- ------------------------------ Gietz           Higgins                  1 /Higgins/Gietz Gietz           King                     3 /King/Kochhar/Higgins/Gietz Gietz           Kochhar                  2 /Kochhar/Higgins/Gietz Higgins         King                     2 /King/Kochhar/Higgins Higgins         Kochhar                  1 /Kochhar/HigginsThe 何用汇总following example uses a GROUP BY clause to return the total salary of each employee in department 110 and all employees below that employee in the hierarchy: 1.2.3.4.5.6.7.

如何用Oracle实现组织结构中的汇总统计