我想查找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