sql开发
-
编辑 删除
递归查询(一)：connect by
语法： { CONNECT BY [ NOCYCLE ] condition [ START WITH condition ]| START WITH condition CONNECT BY [ NOCYCLE ] condition}START WITH:specifies the root row(s) of the hierarchy.CONNECT BY:specifies the relationship between parent rows and child rows of the hierarchy. 1.In a hierarchi...
