select sum(MMoney) from (
select sum(MMoney) as MMoney FROM [MProfit] group by mname having sum([MMoney]) > 50
) as a再聚合一次
select sum(MMoney) as MMoney FROM [MProfit] group by mname having sum([MMoney]) > 50
) as a再聚合一次
也可以将select sum(MMoney) FROM [MProfit] group by mname having sum([MMoney]) > 50执行结果导入到一张表中(select into),然后再执行求和函数