执行结果如下图：
sql面试题-----行转列
标签：bsp 试题 http img ima pre .com 技术分享 div
sql面试题-----行转列
select Time as 日期,
2 sum
3 (
4 case
5 when Shengfu=‘胜‘ then 1
6 else 0
7 end
8 ) as 胜,
9 sum
10 (
11 case
12 when Shengfu=‘负‘ then 1
13 else 0
14 end
15 ) as 负
16
17 from tem
18 group by Time