SQL Oracle µÝ¹é²éѯÓï¾ä

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