字段如何进行sum计算? 如果有a,b两个字段:a代表月份b销售额如何做如下统计:条件a=0时,sum(b) c条件a=1时,sum(b) d然后最后生成如下结构:a c d 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a, c=sum(case when a=0 then b else 0), d=sum(case when a=1 then b else 0)from tb where a in(1,0) group by a --少endselect a, c=sum(case when a=0 then b else 0 end), d=sum(case when a=1 then b else 0 end)from tb where a in(1,0) group by a select a, sum(case when a=0 then b else 0) as c, sum(case when a=1 then b else 0) as dfrom tb group by a sum(case when a=0 then b else 0) c,sum(case when a=1 then b else 0) c select a, sum(case when a=0 then b else 0 end) as c, sum(case when a=1 then b else 0 end) as dfrom tb group by a抄袭的下场 也没END select 月份a,case a when 0 then select sum(b) from TB where a=0 end as c,case a when 1 then select sum(b) from TB where a=1 end as d from TB这样应该可以!你看看! select a,sum(case when a=0 then b else o end),sum (case when a=1 then b else o end)from table group by a 忘记别名。。select a,sum(case when a=0 then b else o end) as c,sum (case when a=1 then b else o end) as dfrom table group by a SELECT A,SUM(CASE WHEN A=0 THEN B ELSE 0 END )AS C,SUM(CASE WHEN A=1 THEN B ELSE 0 END )AS DFROM TB GROUP BY A 求一SQL语句 sql server 怎么用批处理备份和删除数据库文件 请教高手,如何判断表的存在并返回标识 SQL Server2005复制之后自动增长列从1开始增长 。。。 如何为日期字段指定默认值! SQL Server数据库连接字符串问题,请高手进来帮解决,棘手! 数据库 正在恢复 关于execl与存储过程的问题 请问SQL server中的如何实现自动编号? 求一SQL语句 一个很简单的组合查询的问题
c=sum(case when a=0 then b else 0),
d=sum(case when a=1 then b else 0)
from tb where a in(1,0) group by a
select a,
c=sum(case when a=0 then b else 0 end),
d=sum(case when a=1 then b else 0 end)
from tb where a in(1,0) group by a
a,
sum(case when a=0 then b else 0) as c,
sum(case when a=1 then b else 0) as d
from
tb
group by
a
a,
sum(case when a=0 then b else 0 end) as c,
sum(case when a=1 then b else 0 end) as d
from
tb
group by
a
抄袭的下场 也没END
select 月份a,case a when 0 then select sum(b) from TB where a=0 end as c,case a when 1 then select sum(b) from TB where a=1 end as d
from TB
这样应该可以!你看看!
select a,
sum(case when a=0 then b else o end),
sum (case when a=1 then b else o end)
from table group by a
sum(case when a=0 then b else o end) as c,
sum (case when a=1 then b else o end) as d
from table group by a
A,
SUM(CASE WHEN A=0 THEN B ELSE 0 END )AS C,
SUM(CASE WHEN A=1 THEN B ELSE 0 END )AS D
FROM TB GROUP BY A