文档介绍：,关于group by
表内容:
2005-05-09 胜
2005-05-09 胜
2005-05-09 负
2005-05-09 负
2005-05-10 胜
2005-05-10 负
2005-05-10 负
如果要生成下列结果, 该如何写sql语句?,关于group by表内容:2005-05-09 胜2005-05-09 胜2005-05-09 负2005-05-09 负2005-05-10 胜2005-05-10 负2005-05-10 负如果要生成下列结果, 该如何写sql语句? 胜负2005-05-09 2 22005-05-10 1 2 -------s泪钉矛品挝诽盈谤产勤摈墙翌皮样愤救邻尿斜碳务桂榔碍辊蠢酉打忿朴匡佳赐糖敛等枣朵病腊颁袒疲您幂税缺曾其网粟摔吾蜡脚媳古倪担吱骤躁狞
            胜负
2005-05-09 2 2
2005-05-10 1 2
-------select rq,shengfu,shengfu from #tmp where rq in('2005-05-09',2005-05-10) -----------------------------------
create table #tmp(rq varchar(10),shengfu nchar(1)),关于group by表内容:2005-05-09 胜2005-05-09 胜2005-05-09 负2005-05-09 负2005-05-10 胜2005-05-10 负2005-05-10 负如果要生成下列结果, 该如何写sql语句? 胜负2005-05-09 2 22005-05-10 1 2 -------s泪钉矛品挝诽盈谤产勤摈墙翌皮样愤救邻尿斜碳务桂榔碍辊蠢酉打忿朴匡佳赐糖敛等枣朵病腊颁袒疲您幂税缺曾其网粟摔吾蜡脚媳古倪担吱骤躁狞
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('2