56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT [date] ,
SUM(CASE WHEN result = 'win' THEN 1
ELSE 0
END) AS win,
SUM(CASE WHEN result = 'lose' THEN 1
ELSE 0
END) AS lose
FROM #T
GROUP BY [date]
把#T换成你的表名--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([date] Date,[result] nvarchar(24))
Insert #T
select '2005-05-09',N'win' union all
select '2005-05-09',N'lose' union all
select '2005-05-09',N'lose' union all
select '2005-05-09',N'win' union all
select '2005-05-10',N'win' union all
select '2005-05-10',N'lose' union all
select '2005-05-10',N'lose'
Go
--测试数据结束
SELECT [date] ,
SUM(CASE WHEN result = 'win' THEN 1
ELSE 0
END) AS win,
SUM(CASE WHEN result = 'lose' THEN 1
ELSE 0
END) AS lose
FROM #T
GROUP BY [date]