如何查找总和

怎么查找总和？



我想查找SceneId为1 2 3 的各个ApplyNumber的总和的语句怎么写了？


[解决办法]
select sceneid,sum(applynumber) as applynumber
from tab_name
where sceneid in (1,2,3)
group by sceneid
[解决办法]

SQL code

select SceneId,sum(ApplyNumber) from tb group by SceneId
[解决办法]
SQL code
select SceneId,sum(ApplyNumber) [ApplyNumber_Total]from Applygroup by SceneId
[解决办法]
SQL code
select sceneid,sum(applynumber)  totalapplynumber from tblgroup by sceneid