sql中根据父节点获取所有的子节点语句
WITH sub_nodes(pk_id) AS (SELECT pk_id FROM IBP_T_Regions WHERE iparentid 56UNION ALLSELECT tn.pk_id FROM IBP_T_Regions tnJOIN IBP_T_Regions s ON tn.iparentid s.pk_id
)
SELECT * FROM sub_nodes;如果修改指定父节点所有子节点的部门id值如下:WITH su…
2026/8/22 16:14:22