求助Sql在線等。。。

Question

           A表
User_on    User_name   Top_id
0015          AA          
0012          BB          0015
0013          CC          0015
0018          DD          0015
0024          EE          0012
0028          FF          0012
0026          GG          0013
0026          HH          0013
0036          II          0028
0042          JJ          0028
0058          KK          0042
0076          NN          0058 查詢條件為 0015   查詢得到的結果是下表                                       查詢條件為 0012   查詢得到的結果是下表 
User_on   User_name   Top_id                                                     User_on   User_name   Top_id
0015        AA                                                                   0012        BB          0015
0012        BB          0015                                                     0024        EE          0012
0013        CC          0015                                                     0028        FF          0012
0018        DD          0015                                                     0036        II          0028
0024        EE          0012                                                     0042        JJ          0028
0028        FF          0012                                                     0058        KK          0042
0026        GG          0013                                                     0076        NN          0058
0026        HH          0013
0036        II          0028
0042        JJ          0028
0058        KK          0042
0076        NN          0058
能否用一個SQL語句實現  謝謝大家！

Answer 1

select * from a
connect by prior user_on=Top_id
start with user_on='15'将15换成12就是右边的结果

Answer 2

结果有些看不动，不过安装表的数据来说 有父子这样的关系，如果是要做树型结构的查询。用connect by吧。

Answer 3

select * from a start with user_on = '0015' connect by top_id = prior user_on;