行转列

 

select *from Result
select Time 日期,
sum
(
case
when Grade='胜' then 1
else 0
end
) as 胜,
sum
(
case
when Grade='负' then 1
else 0
end
) as 胜
from Result
group by Time