ms sql 高手请进? 在线等!!!

jdabin 2011-01-08 04:22:20
select sum(changeMoney) as 变动总额 from dbo.ChangeMoneyInfo
select sum(changeMoney) as 消费总额 from dbo.ChangeMoneyInfo where typeID=1
select sum(changeMoney) as 存款总额 from dbo.ChangeMoneyInfo where typeID=2
select sum(changeMoney) as 取款总额 from dbo.ChangeMoneyInfo where typeID=3


怎么写成一句SQL 语句查出来?
...全文
111 8 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
jdabin 2011-01-08
  • 打赏
  • 举报
回复
谢了 你们的比我的灵活, 如果要其他表的数据 你们的要 方便很多
jdabin 2011-01-08
  • 打赏
  • 举报
回复

select sum(changeMoney) as 变动总额 ,
sum(case typeID when 1 then changeMoney else 0 end) as 下单,
sum(case typeID when 2 then changeMoney else 0 end) as 撤单,
sum(case typeID when 3 then changeMoney else 0 end) as 存款,
sum(case typeID when 4 then changeMoney else 0 end) as 取款,
sum(case typeID when 5 then changeMoney else 0 end) as 中奖,
sum(case typeID when 6 then changeMoney else 0 end) as 返点
--,sum(select count(addtime) from userInfo where addtime>'2010-1-8' and addtime<'2010-1-8')
from dbo.ChangeMoneyInfo ----这样也可以...
joyhen 2011-01-08
  • 打赏
  • 举报
回复
外面套个select就行了啊
feixianxxx 2011-01-08
  • 打赏
  • 举报
回复
[Quote=引用 4 楼 llpoo 的回复:]

select
(select sum(changeMoney) as 变动总额 from dbo.ChangeMoneyInfo),
(select sum(changeMoney) as 消费总额 from dbo.ChangeMoneyInfo where typeID=1),
(select sum(changeMoney) as 存款总额 from dbo.ChangeMone……
[/Quote]
...是这样吧..
select
(select sum(changeMoney) as 变动总额 from dbo.ChangeMoneyInfo),
(select sum(changeMoney) as 消费总额 from dbo.ChangeMoneyInfo where typeID=1),
(select sum(changeMoney) as 存款总额 from dbo.ChangeMoneyInfo where typeID=2),
(select sum(changeMoney) as 取款总额 from dbo.ChangeMoneyInfo where typeID=3)
llpoo 2011-01-08
  • 打赏
  • 举报
回复
select
(select sum(changeMoney) as 变动总额 from dbo.ChangeMoneyInfo),
(select sum(changeMoney) as 消费总额 from dbo.ChangeMoneyInfo where typeID=1),
(select sum(changeMoney) as 存款总额 from dbo.ChangeMoneyInfo where typeID=2),
(select sum(changeMoney) as 取款总额 from dbo.ChangeMoneyInfo where typeID=3)
from ChangeMoneyInfo
jdabin 2011-01-08
  • 打赏
  • 举报
回复
jdabin 2011-01-08
  • 打赏
  • 举报
回复
晕了这都很难么?
jdabin 2011-01-08
  • 打赏
  • 举报
回复
changeMoney money 类型. 应该不需要其它数据了吧!

34,838

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧