不好说明,自己多琢磨琢磨就能看懂,附上表,自己看,应该能懂
select COUNT(1)
from CP_NFAULTEVENT C
start with C.PARENTID=1
connect by prior C.EVENTCATEID=C.PARENTID
不好说明,自己多琢磨琢磨就能看懂,附上表,自己看,应该能懂
select COUNT(1)
from CP_NFAULTEVENT C
start with C.PARENTID=1
connect by prior C.EVENTCATEID=C.PARENTID