不能对包含聚合或子查询的表达式执行聚合函数。
select sum(jsry), sum(CAST(CAST((jsry)*1.0*100/(select (gc+zc+zgj+xzry+gqry+scry+jsry+bzgry) from (
select row_number()over(order by (select 1), CONCAT(nf,'年',yf,'月') desc )rn,* from att_ydryqkb where bmid='2847d353-670e-42f9-964d-955403cb626e'
)t where rn=1 ) as decimal(10,2)) as varchar(50))) +'%' from att_ydryqkb where bmid='2847d353-670e-42f9-964d-955403cb626e' or parentid='2847d353-670e-42f9-964d-955403cb626e'