sql面试题-----行转列

   tem数据表如下图

select Time as 日期,
sum 
(
         case 
     when Shengfu='胜'  then 1
       else  0
      end
) as 胜,
sum
( 
       case
     when Shengfu='负' then 1
        else 0
     end 
)  as 负

 from tem
   group by Time

执行结果如下图：