行列转换统计

最新推荐文章于 2022-06-24 17:46:34 发布

wsich

最新推荐文章于 2022-06-24 17:46:34 发布

阅读量350

点赞数 1

分类专栏： T-SQL 文章标签： insert table

本文链接：https://blog.csdn.net/wsich/article/details/6632343

版权

T-SQL 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

insert into tb1 values('2005-05-09','胜')
insert into tb1 values('2005-05-09','胜')
insert into tb1 values('2005-05-09','负')
insert into tb1 values('2005-05-09','负')
insert into tb1 values('2005-05-10','负')
insert into tb1 values('2005-05-10','负')
insert into tb1 values('2005-05-10','胜')

select rq,jg,count(jg) as cs into #t
from tb1
group by rq,jg
order by rq

select rq,sum(case jg when '胜' then cs else 0 end) as '胜',sum(case jg when '负' then cs else 0 end ) as '负'
from #t
group by rq

drop table #t

rq                                                    胜           负
------------------------------------------------------ ----------- -----------
2005-05-09 00:00:00.000          2           2
2005-05-10 00:00:00.000          1           2