select sum(MMoney) FROM [MProfit] group by mname having sum([MMoney]) > 50
如何统计这一列的总和
------解决思路----------------------
可以再聚合一次
------解决思路----------------------
select sum(MMoney) from (
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）,然后再执行求和函数