论坛 › SQL Server › [Sql]树结构表，查询所有末级节点

loyalxuan 发表于 2018-10-20 12:46:44

[Sql]树结构表，查询所有末级节点

select t."CLASS_CODE",t."CLASS_NAME",t."FATHER_CLASS_CODE",t."CLASS_STATE",t."OP_USER",t."OP_TIME",t."IS_PROJECT",nvl(t2.isParent,0) isParent from FSS_PROJECT_CLASS t　　
LEFT JOIN (
　　
SELECT count(1) isParent,FATHER_CLASS_CODE from FSS_PROJECT_CLASS GROUP BY FATHER_CLASS_CODE
　　
) t2
　　
on t.CLASS_CODE = T2.FATHER_CLASS_CODE;

查看完整版本: [Sql]树结构表，查询所有末级节点