sqlserver递归查询平均数怎么查

with cte_Assess(id,pid,code,target,score)
as

(

--起始条件

select id,pid,code,target,score
from Assess

where id = 937 --列出子节点查询条件

union all  

--递归条件  
select a.id,a.pid,a.code,a.target,a.score
from Assess a  
inner join   
cte_Assess b          --执行递归
on a.pid=b.id 

)

select * from cte_Assess t;

```我想要的只是拿score的平均数，其他可拿可不

--获取某层下的所有信息--
with cte_Assess(id,pid,code,target,score)
as
(
--起始条件
select id,pid,code,target,score
from Assess
where id = 937 --列出子节点查询条件
union all  
--递归条件  
select a.id,a.pid,a.code,a.target,a.score
from Assess a  
inner join   
cte_Assess b          --执行递归
on a.pid=b.id 
)
--求出平均分--
select avg(score) from cte_Assess

https://www.cnblogs.com/furenjian/p/5098982.html

with temp ( [Id], [parentid])
as
(
select Id, parentid
from DiGui
where [parentid] = 15
union all
select a.Id, a.parentid
from DiGui a
inner join temp on a.[parentid] = temp.[Id]
)
select * from temp

select convert(varchar,time,23),datepart(hh,time),avg(valueavg),max(valueavg)
from tb group by convert(varchar,time,23),datepart(hh,time)
韩国留学家长陪读需要提供哪些资料www.fenbiedu.cn/index/answer/detail/id/31.html