sql 问题

Question

在一个表中有四个字段分别是
bgd_UserCode,bgd_BetReturn,bgd_PlayerBetReturn,bgd_TieBetRetrun
 1 5     6 7
 1 5    20 20
 2 5    20 15我想根据bgd_UserCode  查询bgd_BetReturn，bgd_PlayerBetReturn，bgd_TieBetRetrun 的总和怎么弄呀

Answer 1

select bgd_UserCode ,sum(bgd_BetReturn), sum(bgd_PlayerBetReturn), sum(bgd_TieBetRetrun) from table group by bgd_UserCode 

Answer 2

如上，如果需要bgd_BetReturn,bgd_PlayerBetReturn,bgd_TieBetRetrun三者的总和
确定bgd_BetReturn,bgd_PlayerBetReturn,bgd_TieBetRetrun都是数值型
select bgd_UserCode ,sum(bgd_BetReturn+bgd_PlayerBetReturn+bgd_TieBetRetrun) from table group by bgd_UserCode

Answer 3

select sum(bgd_BetReturn+bgd_PlayerBetReturn+bgd_TieBetRetrun) from table where bgd_UserCode = 2

Answer 4

我知道怎么搞的了，谢谢大家了
(sum(isNull(bgd_BetReturn,0))+sum(isNull(Bgd_PlayerBetReturn,0))+sum(isNull(bgd_TieBetReturn,0))) as t_Count