科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道如何在Oracle层次查询中给SIBLINGS排序

如何在Oracle层次查询中给SIBLINGS排序

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

Oracle SELECT语句中的START WITH和CONNECT BY子句自动阻断一个层次。缺少这项特性,就需要一个复杂的自联接来确定行之间的逻辑联系。

作者:builder.com.cn 2007年1月22日

关键字: ORACLE

  • 评论
  • 分享微博
  • 分享邮件

在本页阅读全文(共3页)

SQL> @siblings_without_orderby

Reports To                     EMPLOYEE_ID                                     
------------------------------ -----------                                      
Kochhar                                101                                     
  Whalen                               200                                     
  Mavris                               203                                      
  Baer                                 204                                     
  Higgins                              205                                     
    Gietz                              206                                     
  Greenberg                            108                                     
    Faviet                             109                                     
    Chen                               110                                     
    Sciarra                            111                                     
    Urman                              112                                     
    Popp                               113                                     
De Haan                                102                                     
  Hunold                               103                                     
    Ernst                              104                                     
    Austin                             105                                      
    Pataballa                          106                                     
    Lorentz                            107                                     

18 rows selected.

SQL> @siblings_with_orderby

Reports To                     EMPLOYEE_ID                                     
------------------------------ -----------                                     
De Haan                                102                                     
  Hunold                               103                                     
    Austin                             105                                     
    Ernst                              104                                     
    Lorentz                            107                                     
    Pataballa                          106                                     
Kochhar                                101                                     
  Baer                                 204                                      
  Greenberg                            108                                     
    Chen                               110                                     
    Faviet                             109                                      
    Popp                               113                                     
    Sciarra                            111                                     
    Urman                              112                                      
  Higgins                              205                                     
    Gietz                              206                                     
  Mavris                               203                                     
  Whalen                               200                                     

18 rows selected.

SQL>

 

    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章