select t.*,
(select count(1)
from (select connect_by_isleaf isleaf
from efficiency_selfassess_mould
start with id = t.id--t.id执行时说找不到
connect by prior id = parent_id)
where isleaf = 1)
from efficiency_selfassess_mould t
start with item_id = '0a6b5afe-5e05-40ba-b770-99a07c856b8c'
connect by prior id = parent_id
是oracle写的