Select bgl_GameInfoId,
sum(t_RowNum) as t_RowNum
From (Select bgl_GameInfoId,
(case when SIGN(bgd_BankerBet) < 0 then 0 else SIGN(bgd_BankerBet) end)+
(case when SIGN(bgd_PlayerBet) < 0 then 0 else SIGN(bgd_PlayerBet) end)+
(case when SIGN(bgd_TieBet) < 0 then 0 else SIGN(bgd_TieBet) end) -1 as t_RowNum
From vw_BaccaratGameList inner join vw_BaccaratGameDetails on bgl_Id=bgd_GameId
) as TempGameList
group by bgl_GameInfoId
我想在这个行的结果算出来后减去一,但是有个条件如果bgd_BetReturn <= 0 就不减去1,如果小于0的话就减去一,
上面写的我减去一了,帮忙看下啊,条件应该怎么样添加进去
sum(t_RowNum) as t_RowNum
From (Select bgl_GameInfoId,
(case when SIGN(bgd_BankerBet) < 0 then 0 else SIGN(bgd_BankerBet) end)+
(case when SIGN(bgd_PlayerBet) < 0 then 0 else SIGN(bgd_PlayerBet) end)+
(case when SIGN(bgd_TieBet) < 0 then 0 else SIGN(bgd_TieBet) end) -1 as t_RowNum
From vw_BaccaratGameList inner join vw_BaccaratGameDetails on bgl_Id=bgd_GameId
) as TempGameList
group by bgl_GameInfoId
我想在这个行的结果算出来后减去一,但是有个条件如果bgd_BetReturn <= 0 就不减去1,如果小于0的话就减去一,
上面写的我减去一了,帮忙看下啊,条件应该怎么样添加进去
解决方案 »
- 请教一下asp.net中的treegrid
- 页面加载速度问题
- asp.net数据绑定问题,高手进
- aspx页的标签里出现这个是什么意思:__designer:wfdid
- showModalDialog为什么不能用window.opener.location.reload()刷新父级页面
- owc问题?
- 已知时间为某年某月某日,请问一下怎么判断它是星期几?
- 江湖救急!!图片文件字节内容转换成Base64的字符串
- 关于如何用javascript 做到校验 TextBox1 和 TextBox2 不能同时为空的问题
- 大家查看页面不能转移的错误
- asp.net中如何生成excel文件并打开在网页中
- java里面soap.jar有对应的.net的dll吗
when 1 then '女'
else '男'
end
sum(t_RowNum) as t_RowNum
From (Select bgl_GameInfoId,
(case when SIGN(bgd_BankerBet) < 0 then 0 else SIGN(bgd_BankerBet) end)+
(case when SIGN(bgd_PlayerBet) < 0 then 0 else SIGN(bgd_PlayerBet) end)+
(case when SIGN(bgd_TieBet) < 0 then 0 else SIGN(bgd_TieBet) end) -
(case when bgd_BetReturn>0 then 1 else 0 end) as t_RowNum
From vw_BaccaratGameList inner join vw_BaccaratGameDetails on bgl_Id=bgd_GameId
) as TempGameList
group by bgl_GameInfoId