日期:2014-05-17 浏览次数:20753 次
SELECT NAME , [胜] = SUM(CASE WHEN score = N'胜' THEN 1 ELSE NULL END) , [负] = SUM(CASE WHEN score = N'负' THEN 1 ELSE NULL END) FROM T_Scores GROUP BY NAME