17,089
社区成员
发帖
与我相关
我的任务
分享
sum(case when shengfu='胜' then 1 else 0 end) "胜",
select rq,
sum(case when shengfu='胜' then 1 else 0 end) 胜,
sum(case when shengfu='负' then 1 else 0 end) 负
from #tmp
group by rq
--or
select rq,
sum(case when shengfu='胜' then 1 else 0 end) "胜",
sum(case when shengfu='负' then 1 else 0 end) "负"
from #tmp
group by rq
create table tmp(rq varchar2(10),shengfu nchar(1));
insert into tmp values('2005-05-09','胜');
insert into tmp values('2005-05-09','胜');
insert into tmp values('2005-05-09','负');
insert into tmp values('2005-05-09','负');
insert into tmp values('2005-05-10','胜');
insert into tmp values('2005-05-10','负');
insert into tmp values('2005-05-10','负');
select rq,
sum(case when shengfu='胜' then 1 else 0 end)"胜",
sum(case when shengfu='负' then 1 else 0 end)"负"
from tmp
group by rq
--
RQ 胜 负
--------------- ---------- ----------
2005-05-10 1 2
2005-05-09 2 2
select rq,
sum(case when shengfu='胜' then 1 else 0 end) 胜,
sum(case when shengfu='负' then 1 else 0 end) 负
from #tmp
group by rq