如图:
------解决方案--------------------
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
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