胜负

create table tmp(rq varchar(10),shengfu nchar(1))select * from tmpinsert 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 1else 0end)as 胜,sum(case when shengfu='负'then 1else 0end)as 负from tmpgroup by rq