SQL SERVER 2008 递归子查询语句
WITH lmenu(id,orgFather,orgName,level) as
(
SELECT id,orgFather,orgName,0 level FROM ORGANIZATION WHERE id='6c41bce0-4451-4a9f-aaba-dc3a9da0c30c'
UNION ALL
SELECT A.id,A.orgFather,A.orgName,b.level+1 FROM ORGANIZATION A,lmenu b
where a.orgFather = b.id
)
SELECT * from lmenu
ORACLE 递归父类查询
SELECT * FROM CDT_ARTICLE_TYPE START WITH LBBH = 8499 CONNECT BY PRIOR SJLBBH = LBBH ORDER BY ORD ASC