select [date] as 日期,count(case when result='胜' then 1 end) as 胜,count(case when result='负' then 1 end) as 负 from T group by [date];

------解决方案--------------------
探讨

SQL code

select [date] as 日期,count(case when result='胜' then 1 end) as 胜,count(case when result='负' then 1 end) as 负 from T group by [date];


------解决方案--------------------
SQL行列转换

------解决方案--------------------
引用:

select [date] as 日期,count(case when result='胜' then 1 end) as 胜,count(case when result='负' then 1 end) as 负 from T group by [date];
[/Quote]