数据行变列

CREATE TABLE [dbo].[Table_2](
	[rq] [datetime] NOT NULL,
	[shengfu] [nvarchar](4) NOT NULL
) ON [PRIMARY]


--insert into Table_2(rq,shengfu) values('2010-9-1','胜')
--insert into Table_2(rq,shengfu) values('2010-9-1','胜')
--insert into Table_2(rq,shengfu) values('2010-9-1','负')
--insert into Table_2(rq,shengfu) values('2010-9-1','负')
--insert into Table_2(rq,shengfu) values('2010-9-2','负')
--insert into Table_2(rq,shengfu) values('2010-9-2','负')
--insert into Table_2(rq,shengfu) values('2010-9-2','负')
--insert into Table_2(rq,shengfu) values('2010-9-2','胜')

生成格式如下：

 

rq	胜	负
2010-09-01	2	3
2010-09-02	1	3

 

select rq, sum(CASe when shengfu ='胜' then 1 else 0 end) as 胜,
sum( CASe when shengfu ='负' then 1 else 0 end) as 负
from Table_2
group by rq