数据库为postgresql文章来源地址https://www.toymoban.com/news/detail-529678.html
WITH RECURSIVE cte AS (
SELECT
n. ID,
n. com_name,
n."parentId" AS pid
FROM
company AS n
WHERE
n. ID = 2
UNION ALL
SELECT
r. ID,
r. com_name,
cte. ID AS pid
FROM
cte
JOIN company AS r ON r.
文章来源:https://www.toymoban.com/news/detail-529678.html
到了这里,关于查询子节点 postgresql的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!