本文深入探讨了SQL中的Pivot操作与Case语句的使用技巧，通过具体实例展示了如何利用Pivot进行数据透视，以及如何运用Case语句进行条件求和。适合对SQL查询感兴趣或希望提升SQL技能的读者。
select * from V_TEST_TEST_TEMP
select * from （select NAME,NUMS from V_TEST_TEST_TEMP）pivot (max(NUMS) for NAME in ( 'a','b','c' ));
select * from （select NAME,NUMS from V_TEST_TEST_TEMP）pivot (max(NUMS) for NAME in ( 'a' as a,'b','c' ));
SELECT NAME,
SUM(DECODE(NAME,'a',NUMS,0)) AS a,
SUM(DECODE(NAME,'b',NUMS,0)) AS b,
SUM(DECODE(NAME,'c',NUMS,0)) AS c
FROM V_TEST_TEST_TEMP GROUP BY NAME ORDER BY NAME
扫一扫
1638
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
