--向下递归查询

with temp (FolderName,id,ParentID)

as(

select a.FolderName,id,ParentID from NC_FolderInFo a where ParentID=105

union all

select m.FolderName,m.id,m.ParentID from NC_FolderInFo  as m

inner join temp as child  on m.ParentID = child.ID

)

select count(1) from temp t

inner join NC_FileInfo f on (t.id = f.FolderID_FK)

where IsEnable is null;

　　

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。