执行下边语句select (select isnull(cast(sum(Money) as numeric(10,2)),0) from WayInfos where InfosID=Infos.ID and WayClassID=1 and WaySortID=1) as Money1,
(select isnull(cast(sum(Money) as numeric(10,2)),0) from WayInfos where InfosID=Infos.ID and WayClassID=2 and WaySortID=1) as Money2,
cast(Money as numeric(10,2)) as Money3
FROM Infos
where Infos.Name='张三' ORDER BY Infos.ID DESC显示出 名字为“张三”的所有费用明细
Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00这个语句怎么能再进行修改可以显示的合计数据为Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00合计Money1:7.52
合计Money2:6.48
合计Money3:14.00
sql查询合计
(select isnull(cast(sum(Money) as numeric(10,2)),0) from WayInfos where InfosID=Infos.ID and WayClassID=2 and WaySortID=1) as Money2,
cast(Money as numeric(10,2)) as Money3
FROM Infos
where Infos.Name='张三' ORDER BY Infos.ID DESC显示出 名字为“张三”的所有费用明细
Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00这个语句怎么能再进行修改可以显示的合计数据为Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00合计Money1:7.52
合计Money2:6.48
合计Money3:14.00
sql查询合计
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货