帮我看看这个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/07/06 14:12:00
![帮我看看这个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](/uploads/image/z/6750392-32-2.jpg?t=%E5%B8%AE%E6%88%91%E7%9C%8B%E7%9C%8B%E8%BF%99%E4%B8%AAoracle%E8%AF%AD%E5%8F%A5%2Cselect+groupid%2Cparentid%2Cgroupname%2Cisleaf%2Cdescription%2Csharerankid%2Cstatusid%2Ccorporationid%2Cstaffid%2Cisactual%2Cgroupcount%2Clevel+FROM+%28SELECT+a.%2A%2Cb.groupcount+FROM+teabgroup+a%2C%28SELECT+groupid%2Ccount%28%2A%29+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 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:递归层数