sqlserver递归查询平均数怎么查

Question

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的平均数，其他可拿可不

Answer 1

--获取某层下的所有信息--
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