帮我看看这个oracle语句,select groupid,parentid,groupname,isleaf,description,sharerankid,statusid,corporationid,staffid,isactual,groupcount,level FROM (SELECT a.*,b.groupcount FROM teabgroup a,(SELECT groupid,count(*) groupcount FROM teabmembe

来源：学生作业帮助网 编辑：作业帮 时间：2024/11/25 06:31:33
帮我看看这个oracle语句,select groupid,parentid,groupname,isleaf,description,sharerankid,statusid,corporationid,staffid,isactual,groupcount,level FROM (SELECT a.*,b.groupcount FROM teabgroup a,(SELECT groupid,count(*) groupcount FROM teabmembe
xSn@}LQ.*JTiPq q,@QJICڔBRnix_0ޭ[="Yx3g -Er;kx_wcIa4z!+dz uY5!` ed(2. ِf*`<G4LlV tb%Kf+\PTUSPDznwQd9s'3G86#K 2Ya!D2Xd&~F*eQNzWgn0oXr)~ዎn!3D\2<(r%ZCI4ˣ< L\vq1:.o2U},ɯwhlYDM:L:lб5tuoAm m>A'ێ}L-gR]I{vF=R;= ر_|m!1Wig=g5\6_Z}km7

帮我看看这个oracle语句,select groupid,parentid,groupname,isleaf,description,sharerankid,statusid,corporationid,staffid,isactual,groupcount,level FROM (SELECT a.*,b.groupcount FROM teabgroup a,(SELECT groupid,count(*) groupcount FROM teabmembe
帮我看看这个oracle语句,
select groupid,parentid,groupname,isleaf,description,sharerankid,
statusid,corporationid,staffid,isactual,groupcount,level
FROM (SELECT a.*,b.groupcount FROM teabgroup a,(
SELECT groupid,count(*) groupcount
FROM teabmember GROUP BY groupid) b
WHERE a.groupid=b.groupid(+) and a.corporationid = 0 )
START WITH parentid=0
CONNECT BY PRIOR groupid=parentid
声明这里面有个level字段在这两张表中是不存在的,一直不知道为什么.不存在也能查出来的.并且查出的结果就是level1或者level2的,为什么?
请问怎么个递归查询?是根据什么来递归的.根据我的某一个变量?

帮我看看这个oracle语句,select groupid,parentid,groupname,isleaf,description,sharerankid,statusid,corporationid,staffid,isactual,groupcount,level FROM (SELECT a.*,b.groupcount FROM teabgroup a,(SELECT groupid,count(*) groupcount FROM teabmembe
oracle中,递归查询的时候,level是个隐式变量,数字类型的
level:递归层数