sql server不能对包含聚合或子查询的表达式执行聚合函数？

Question

select rm.branch_no as csendstordocid, rm.flow_no,rm.item_no as cmaterialvid,
sum(CASE
(select count(distinct rm2.sell_way)
from [dbo].[t_rm_saleflow] rm2
WHERE
rm2.flow_no=rm.flow_no )
WHEN '2' then
CASE rm.sale_price
WHEN '0' THEN rm.source_price
ELSE rm.sale_price END
ELSE rm.sale_price END) as nqtorigtaxprice,
rm.sale_qnty as nnum,rm.sale_qnty as nastnum,rm.branch_no as csendstockorgid
from [dbo].[t_rm_saleflow] rm
WHERE
rm.flow_no='0016001621040100009'

[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]不能对包含聚合或子查询的表达式执行聚合函数。 (130)
加了一个sum统计 报错

Answer 1

聚合 要group by ，case when的语法 感觉也有问题检查下