首页select guid, count(*)-1 as "RESULT COUNT" from ( select connect_by_root(guid) guid from MV_ORG_TREE_PLAN connect by nocycle PGUID = prior GUID start with GUID in ('DB07A72E18424305B3F18CBC5D8F664A', 'FA4FF45B7C804251A62D554BF5260C3E')) group by guid

select guid, count(*)-1 as "RESULT COUNT" from ( select connect_by_root(guid) guid from MV_ORG_TREE_PLAN connect by nocycle PGUID = prior GUID start with GUID in ('DB07A72E18424305B3F18CBC5D8F664A', 'FA4FF45B7C804251A62D554BF5260C3E')) group by guid

时间: 2024-02-14 15:31:15 浏览: 121

guid.zip_The Hidden_guid

This is a Visual Basic 6 project that creates a GUID. It contains the function "CreateGUIDStr()". This function returns a GUID. The function calls some APIs, but this work is hidden from the user. The projects demonstrates its use, and the GUID is displayed in a textbox from which it can be copied. Each click on the "Create GUID" button creates a new GUID and display it in the textbox.

这个查询是在之前的递归查询的基础上进行了进一步的统计。它使用子查询来获取每个根节点和其子节点的数量，并将结果按根节点进行分组。在子查询中，我们使用了之前提到的递归查询，并通过 `CONNECT_BY_ROOT` 引用根节点的 `guid`。然后，我们将这些根节点的 `guid` 作为结果的一部分。接下来，在外部查询中，我们对这些根节点进行分组，并使用 `COUNT(*)-1` 统计每个根节点及其子节点的数量。由于根节点本身也会被计算在内，所以我们需要减去 1。最终，这个查询将返回每个根节点及其子节点数量的结果集，其中包括一个名为 "RESULT COUNT" 的列。如果你有更多的问题，请随时提问！

阅读全文