select *from Resultselect Time 日期,sum(case when Grade=‘胜‘ then 1 else 0 end) as 胜,sum(case when Grade=‘负‘ then 1 else 0 end) as 胜from Resultgroup by Time
行转列
原文：http://www.cnblogs.com/sujulin/p/6537655.html
