树的层次体现的sql方案[@more@]
SQL> select * from test;
ID PARENT_ID
---------- ----------
1 0
2 1
3 2
11 0
22 11
33 22
4 2
44 22
8 rows selected
要得到如下的结果:
ID PARENT_ID 层次
---------- ---------- ----
1 0 0
2 1 1
3 2 2
4 2 2
11 0 0
22 11 1
33 22 2
44 22 2
怎么写这个sql?
SELECT ID,PARENT_ID,(LEVEL - 1) AS N
FROM TEST
START WITH PARENT_ID = 0
CONNECT BY PRIOR ID = PARENT_ID;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/802415/viewspace-836367/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/802415/viewspace-836367/