求表里的Auto_contractID相同的mMoney的和....
意思是一个表有Auto_contractID字段，还有mMoney字段。,求这个表里的Auto_contractID相同的mMoney的和....


[解决办法]
select Auto_contractID,sum(mMoney) as mMoney
from tb
group by Auto_contractID
[解决办法]
多谢lz，接分：）
SELECT Auto_contractID,SUM(mMoney) AS mMoney
FROM tb
GROUP BY Auto_contractID
[解决办法]
select Auto_contractID, mMoney=sum(mMoney)
from tbName
group by Auto_contractID
[解决办法]
接分
[解决办法]
select
Auto_contractID,
[mMoney]=sum(mMoney)
from tbName
group by Auto_contractID--加一个组会合并相同的Auto_contractID

[解决办法]
晕~~为什么我看帖~总这么慢看到