--for example: SQL> select * from test_tab;ID SUB_ID ---------- ---------- A B A B A B B C B C B C B C C D C D C D D E D E12 rows selectedSQL> select distinct id,sub_id from test_taB;ID SUB_ID ---------- ---------- A B B C C D D ESQL> select * from (select distinct id,sub_id from test_taB) 2 start with sub_id = 'B' 3 connect by prior id = sub_id 4 /ID SUB_ID ---------- ---------- A B--A就是B的上阶其实楼主还可以增加一个计数栏位 生成如下数据 ID SUB_ID SUB_NUM A B 1 A B 2 .................. B C 1 B C 2 B C 3 ............... 这样就更方便查询了
SQL> select * from test_tab;ID SUB_ID
---------- ----------
A B
A B
A B
B C
B C
B C
B C
C D
C D
C D
D E
D E12 rows selectedSQL> select distinct id,sub_id from test_taB;ID SUB_ID
---------- ----------
A B
B C
C D
D ESQL> select * from (select distinct id,sub_id from test_taB)
2 start with sub_id = 'B'
3 connect by prior id = sub_id
4 /ID SUB_ID
---------- ----------
A B--A就是B的上阶其实楼主还可以增加一个计数栏位
生成如下数据
ID SUB_ID SUB_NUM
A B 1
A B 2
..................
B C 1
B C 2
B C 3
...............
这样就更方便查询了